Using a modeling tool to generate current table DDL (CMPIN2) and compare … CREATE TABLE TSUAKAC1.BJTDDS ( ROWID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 20 NO ORDER … to the current Db2 table definition (CMPIN1) … CREATE TABLE RK2BASE3.BJTDDS ( ROWID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH 224 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 20 NO ORDER ) … can result in the loss of data via identity column START attribute value in the generated CDL: -CDL 000450 ALTER TABLE C1769630.BJTDDS VOLATILE NO ALTER COLUMN ROWID ( START 1 |
To avoid having CDL generated for an identity column with an incorrect START value, run the compare by including the ALUIN DD NOSTARTVALUE keyword. The attached MS Word document shows panel captures where you can exclude the START attribute from compare. Object attributes for inclusion https://docs.bmc.com/docs/acm13100/object-attributes-for-inclusion-1091944907.html?src=search |