CREATE SEQUENCE "DB2ADMIN"."SEQ_TEST"
START WITH 100000000001
- Oracle MAX VALUE IS 999999999999. Using 2147483647 as max value for DB2 SEQ_TEST
INCREMENT BY 1
The maxvalue is smaller than the start value, and it's wrong.
From the following thread, it looks that this is a fix to old DB2 version. But as I see, in DB2 9.7 FP5, the sequence can be created successfully without "MAXVALUE 2147483647".
Should remove the "MAXVALUE 2147483647" ?