Exam C2090-600 topic 1 question 11 discussion

If you set the DB2_WORKLOAD registry variable to ANALYTICS, a default policy is applied, and the auto_reorg database configuration parameter is set so that automatic reclamation is active for all column-organized tables. https://www.ibm.com/docs/en/db2/10.5?topic=organization-space-reclamation-column-organized-tables.

Ans is D You can start this process manually by specifying the RECLAIM EXTENTS option for the REORG TABLE command, or you can use an automated approach. If you set the DB2_WORKLOAD registry variable to ANALYTICS, a default policy is applied, and the auto_reorg database configuration parameter is set so that automatic reclamation is active for all column-organized tables. For more information, see Enabling automatic table and index reorganization and Configuring an automated maintenance policy.

The reference is good but the answer is wrong. The correct answer is D. Remark 1 : DB2_AUTORECLAIMSPACE does not exist. Remark 2 : AUTO_DEL_REC_OBJ is used to specify whether database log files, backup images, and load copy images should be deleted when their associated recovery history file entry is pruned. Reference : When data is deleted from a column-organized table, the storage extents whose pages held data that was all deleted are candidates for space reclamation. The space reclamation process finds these extents, and returns the pages that they hold to table space storage, where they can later be reused by any table in the table space. You can start this process manually by specifying the RECLAIM EXTENTS option for the REORG TABLE command, or you can use an automated approach. If you set the DB2_WORKLOAD registry variable to ANALYTICS, a default policy is applied, and the auto_reorg database configuration parameter is set so that automatic reclamation is active for all column-organized tables. For more information, see "Enabling automatic table and index reorganization" and "Configuring an automated maintenance policy".