When altering a Table to drop a column, an ALTER TABLE DROP COLUMN is generated, which when executed, will leave the table in Advisory Reorg-Pending state (AREOR).
DSNT404I SQLCODE = 610, WARNING: A CREATE/ALTER ON OBJECT
creator.name HAS PLACED OBJECT IN ADVISORY REORG PENDING
No Reorg utility has been generated after the ALTER. The pending definition changes could result in subsequent DDL failures.
DSNT408I SQLCODE = -20385, ERROR: THE STATEMENT CANNOT BE PROCESSED
BECAUSE THERE ARE PENDING DEFINITION CHANGES FOR OBJECT
object-name OF TYPE object-type (REASON reason-code)