Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
ALTER TABLE statements that commonly put a table in a reorg-pending state include operations that significantly change the table structure. Dropping a column (DROP COLUMN col1) requires the table to be reorganized to reclaim space and restructure the data storage. Adding a primary key constraint (ADD CONSTRAINT pk_tab1 PRIMARY KEY) also places the table in a reorg-pending state because it requires restructuring to enforce the unique constraint and create necessary indexes. Therefore, options B and E are correct.
The correct answers are then : B. ALTER TABLE tab1 DROP COLUMN col1 C. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
Certain ALTER TABLE operations, like dropping a column, altering a column type, or altering the nullability property of a column may put the table into a reorg pending state. In this state, many types of queries cannot be run; you must perform a table reorganization before the table becomes available for some types of queries. However, even with the table in a reorg pending state, in most cases, you can still run the ALTER TABLE statement multiple times without having to run the REORG TABLE command. REFERENCE : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/r0053739.html See section "Multiple ALTER TABLE operations within a single unit of work"