What advantage do block-based buffer pools offer compared to regular buffer pools?
What advantage do block-based buffer pools offer compared to regular buffer pools?
Which statement will create an index for optimal query performance?
The following query is executed frequently against the SALES table: SELECT sales_person,
region FROM sales WHERE region = ‘Quebec’ Which statement will create an index for optimal
query performance?
Which monitoring tool can be used to find out how many data pages have been read from the table space containe
Which monitoring tool can be used to find out how many data pages have been read from the
table space containers for regular, large, and temporary table spaces?
What is the FAILARCHPATH database configuration parameter used for?
What is the FAILARCHPATH database configuration parameter used for?
which HADR sync mode?
An auxiliary HADR standby database must use which HADR sync mode?
What is the recommended method for removing old backup images and log files for a DB2 10.1 database?
What is the recommended method for removing old backup images and log files for a DB2 10.1
database?
Which diagnostic tool can be used to collect metrics on individual SQL statement executions?
Which diagnostic tool can be used to collect metrics on individual SQL statement executions?
Which statement about DB2 Merge Backup is FALSE?
Which statement about DB2 Merge Backup is FALSE?
What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function?
What two types of information can be obtained with the MON_GET_TABLESPACE monitor table
function? (Choose two.)
Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?
Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used
with?