Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?
Which monitoring tool can be used to obtain stripe set information for database managed storage
table spaces?
Which statement about value compression is correct?
Which statement about value compression is correct?
Which statement about compression dictionaries is FALSE?
Which statement about compression dictionaries is FALSE?
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?