-359 THE RANGE OF VALUES FOR THE IDENTITY COLUMN OR SEQUENCE IS EXHAUSTED

Explanation

Db2 attempted to generate a value for an identity column or a sequence object. However, all allowable values have already been assigned.

System action

The statement cannot be processed.

Programmer response

Take one of the following actions:
  • For an identity column, redefine the table with a larger range of values for the identity column. If a MAXVALUE or MINVALUE specification has been made that limits the range of values to be less than the range for the data type of the column, then the column can be altered to expand the range of valid values. Otherwise, the identity column must be re-created, which requires that the table be re-created. First, drop the existing table; then, re-create the table with a different data type for the identity column, specifying a data type that has a larger range of values than the current data type for the identity column.
  • For a sequence object, redefine the sequence with a larger range of values. If a MAXVALUE or MINVALUE specification has been made that limits the range of values to be less than the range for the data type, then the sequence can be altered to expand the range of valid values. Otherwise, the sequence must be re-created using DROP SEQUENCE and CREATE SEQUENCE to cover a larger range of values.

SQLSTATE

23522