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.