Solutions

• Question 1:

The correct answer is B. The database configuration parameter MON_OBJ_METRICS controls the collection of data object metrics of an entire database.

• Question 2:

The correct answers are A and D. The column-organized monitor elements will have _COL_ in their name and the row-organized monitor elements will have _DATA_ in their name.

• Question 3:

The correct answer is C. If you want to generate a detailed report consisting of all the explain data, you can execute the db2exfmt command in a sequence like the following:

Step 1: Enable the Explain facility by setting the current explain mode to EXPLAIN. This will change the CURRENT EXPLAIN MODE special register so that the EXPLAIN facility can capture the explain information without actually executing the SQL statement:

SET CURRENT EXPLAIN MODE EXPLAIN;

Step 2: Run the actual SQL statement in the same session...