When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS, specific configurations are applied to optimize the database for analytical workloads. The PAGESIZE database configuration parameter is set to 32K to accommodate larger data pages, which is beneficial for analytical processing. Additionally, the DFT_TABLE_ORG database configuration parameter is set to COLUMN, as columnar storage is advantageous for read-heavy analytical queries due to its efficient data retrieval and storage compression.
Answers A & D are correct because As soon as we set DB2_WORKLOAD to ANALYTICS, the database is set to organized by columns and page size is set to 32k.
When you set DB2_WORKLOAD to ANALYTICS, and you create a new database : - The parameter "DFT_EXTENT_SZ" is set to 4 (Default Tablespace ExtentSize) - The parameter "AUTO_REORG" is set to ON (Automatic Reorganization) - The parametre DFT_TABLE_ORG is set to COLUMN instead of "ROW".
The correct answers are : A. The PAGESIZE database configuration parameter is set to 32K. D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.