Use MAXASGN option with DDL or MIGR command to assign the start value for a IDENTITY or SEQUENCE column attribute based on the existing maximun assigned value. This option is useful when you use DSCOPY to copy the information. For example, the following DDl is generated with MAXASGN if MAXASSGNEDVAL is 20 for Table T1 CREATE TABLE "JRH"."T1" ( "C1" INTEGER GENERATED ALWAYS AS IDENTITY -- START=1. MAXASSIGNEDVAL=20. ( START WITH 21 , INCREMENT BY 1. , NO CACHE ,NO CYCLE ,MAXVALUE 2147483647. ,MINVALUE -2147483648. ) ,"C2" INTEGER NOT NULL )