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.
 |
NewPush has solutions to fit your business needs. For more than a decade, our focus has been to take on the technical challenges that are the hardest and most time-consumming. Our goal is to free up your resources to focus on the core activities of your business and to drive your business performance. Please visit our main site at newpush.com for more information or call us at +1-303-423-4500.