DB2 10 for z/OS Database Administrator — Question 5

Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

Answer options

• A. When the registry variable DB2_AUTORECLAIMSPACE=YES
• B. After termination all the back-end processes using TERMINATE command
• C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
• D. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

Correct answer: C

Explanation

The correct answer, C, is right because setting the database configuration parameter AUTO_DEL_REC_OBJ to ON enables automatic space reclamation. Options A and D pertain to different registry variables that do not directly influence space reclamation for column-organized tables, while option B is about terminating processes, which is not related to the reclamation feature.