Tag Archives: REORG

DB2 Table Structure Alterations

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 … Continue reading

Posted in DB2 | Tagged , , | Leave a comment