DB2 Version 9.7 for Linux, UNIX, and Windows

Transactions can include an increased limit of ALTER TABLE operations

Beginning with DB2® Version 9.7, you can perform an unlimited number of ALTER TABLE statements within a single transaction. Such transactions can place the table in a reorg pending state; you can perform up to three of these types of transactions before a table reorganization is needed.

Certain ALTER TABLE operations, like dropping a column, altering a column type, or altering the nullability property of a column might put the table into a reorg pending state. In previous versions, you could execute up to three such ALTER TABLE statements before reorganization was necessary.