問題1
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sgl ON '/datal';
CREATE STOGROUP ibmstogroup ON '/data2';
CREATE STOGROUP sg2 ON '/data3';
Which storage group is the default storage group for the TESTDB database?
正確答案: A
問題2
When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?
When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?
正確答案: C
問題3
Where does the DB2 Problem Determination tool (db2pd) get information from?
Where does the DB2 Problem Determination tool (db2pd) get information from?
正確答案: B
問題4
Which statement about the DB2_BCKP COMPRESSION registry variable is TRUE?
Which statement about the DB2_BCKP COMPRESSION registry variable is TRUE?
正確答案: B
問題5
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?
正確答案: D
問題6
What does dsmtop use to gather metrics?
What does dsmtop use to gather metrics?
正確答案: A