When an attribute on a table is dropped, or the data type changes, DB2 sets the table into REORG PENDING state. That prevents a number of operations on the table, which can be problematic for a production database. If there is no way around such a structural change, then a REORG command needs to be issued, such as:
REORG TABLE <table_name>;
to restore normal behavior for the table.
