I'm using DB2 UDB V7.2 for AIX with FP5. I created a table with an identity column, i.e.
CREATE TABLE TESTTBL
(COL1 INTEGER NOT NULL
GENERATED ALWAYS AS IDENTITY
(START WITH 100, INCREMENT BY 1),
By default CACHE 20 will be used on the identity column. Now, I want to change it to NO CACHE. How can I do it? I check the SQL Reference but seems there is no such option in the ALTER TABLE statement.