How is the Query Workload Tuner license installed and enabled?
A. With Data Studio, using the license activation kit.
B. By executing the db2licm command after data server installation.
C. With the Optim Performance Manager Server, using the license activation kit.
D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.
If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?
A. -1
B. 1
C. ON
D. ANY
By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?
A. 15 percent
B. 20 percent
C. 25 percent
D. 30 percent
Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?
A. db2pd
B. Routines
C. EXPLAIN tables
D. Snapshot monitor
E. ACTIVITIES event monitors
Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?
A. db2iupdt-a
B. db2iupdt-update
C. db2iupdt-commit_level
D. db2iupdt-online_update
What is a DB2 Advanced Copy Services (ACS) script used for?
A. To install and configure DB2 Advanced Copy Services.
B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.
C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.
D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.
Which statement about expression-based indexes is true?
A. The RUNSTATS command cannot be used to collect statistics for expression-based indexes.
B. Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.
C. Expression-based index keys consist of a concatenation of one or more specified table columns.
D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.
What are the correct steps to capture EXPLAIN information for column-organized tables?
A. 1. Issue the query against column-organized tables
2. Execute the db2exfmt command
B. 1. Execute the command CURRENT EXPLAIN MODE YES
2.
Issue the query against column-organized tables
3.
Execute the db2exfmt command
C. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2.
Issue the query against column-organized tables
3.
Execute the db2exfmt command
D. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2.
Execute the command CURRENT EXPLAIN MODE YES
3.
Issue the query against column-organized tables
4.
Execute the db2exfmt command
What type of table can be converted into a column-organized table with the db2convert command?
A. A range partitioned table
B. A materialized query table
C. A row-organized user table
D. A declared global temporary table
Which scenario does NOT require intraquery parallelism?
A. The execution of the LOAD command against an empty column-organized table.
B. A DML operation that references a populated column-organized table.
C. The execution of the RUNSTATS command against a populated column-organized table.
D. The addition of a primary key constraint to an empty column-organized table.