Which options are valid for an online reorganization operation?
Which options are valid for an online reorganization operation?
Valid options for an online reorganization operation include FULL and CLEANUP OVERFLOWS. FULL reorganizes the entire table, while CLEANUP OVERFLOWS addresses issues with overflow records in the table. These operations help optimize database performance and ensure data integrity during reorganization tasks.
The answer C "FULL and CLEANUP OVERFLOWS " is correct. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html SEE PARAGRAPH inplace-options
The answer C REORG TABLE db2inst1.sample INPLACE FULL; REORG TABLE db2inst1.sample INPLACE CLEANUP OVERFLOWS;