Error
Operation not allowed for reason code “7” on table “IBMCONSOLE.T1”… SQLCODE=-668, SQLSTATE=57016, DRIVER=4.27.25
The table is in the reorg pending state. This can occur after an ALTER TABLE statement containing a REORG-recommended operation. refer
Why
Starting with Db2® Version 9.7, you can run an unlimited number of ALTER TABLE statements within a single unit of work. In most situations, after processing three units of work that include such operations, the REORG TABLE command must be run.
Starting with Db2 Version 10.5 Fix Pack 5, when the table is in a reorg pending state, the data type of a column can be altered only once before