What does dsmtop use to gather metrics?
What does dsmtop use to gather metrics? A. db2pd B. db2dart C. the system catalog D. monitoring table functions
What does dsmtop use to gather metrics? A. db2pd B. db2dart C. the system catalog D. monitoring table functions
What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT? A. SYSIBM B. SYSFUN C. SYSCAT D. SYSIBMADM
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters? A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables. B. Set the SELF_TUNING_MEM…
Which of the following statements about audit policies is TRUE? A. Audit policy changes are applied instantly and affect all inflight transactions. B. Multiple audit policies can be associated with the same table at the same time. C. The audit…
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1? A. As the db2 instance owner (db2inst1) execute the command:export DB2_FMP_COMM_HEAPSZ=256000 B. Add to…
What is the result of the following scenario? A. The row is updated to (2, NULL) B. The row is updated to (2, 110.00) C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed D.…
Which statement about Data Server Manager (DSM) is TRUE? A. DSM can be used for reviewing audit trails B. DSM cannot be used for database administration C. DSM can be used for configuration management of DB2 Data Server drivers D.…
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…
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption? A. Select from the ADMIN_GET_ENCRYPTION_INFO table function B. Run the db2ckbkp command and verify the compression settings C. Check…
Which phase of the LOAD utility is unique to loading column organized tables? A. LOAD B. BUILD C. DELETE D. ANALYZE