DB2 SQL-Error: -359
SQLState: 23522
Short Description: THE RANGE OF VALUES FOR THE IDENTITY COLUMN OR SEQUENCE IS EXHAUSTED
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: v 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 recreated, which requires that the table be recreated. First, drop the existing table; then, recreate 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. v 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 recreated using DROP SEQUENCE and CREATE SEQUENCE to cover a larger range of values.