DB2 10 for z/OS Database Administrator — Question 22

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

Answer options

• A. The PAGESIZE database configuration parameter is set to 32K.
• B. The AUTO_REORG database configuration parameter is set to NO.
• C. The DFT_EXTENT_SZ database configuration parameter is set to 8.
• D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
• E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

Correct answer: D, E

Explanation

The correct answers are D and E because when the DB2_WORKLOAD is set to ANALYTICS, the DFT_TABLE_ORG is configured as COLUMN to optimize for analytic workloads, and the INTRA_PARALLEL parameter is set to NO to avoid intra-partition parallelism which is not beneficial for such workloads. The other options are incorrect as they do not align with the settings applied in this scenario.