What are the correct steps to capture EXPLAIN information for column-organized tables?
What are the correct steps to capture EXPLAIN information for column-organized tables?
which two capabilities are available?
If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale
database, which two capabilities are available?
Which monitoring function can be used to determine how many times an SQL statement has referenced a particular
Which monitoring function can be used to determine how many times an SQL statement has
referenced a particular column-organized table within a specific period of time?
What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to popul
What happens when the STATISTICS USE PROFILE option is provided with a LOAD command
that will be used to populate a column-organized table and a statistics profile does not exist?
what is the maximum row width size for database tables?
When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum
row width size for database tables?
When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale en
When can a high availability disaster recovery (HADR) role switch operation be performed in a
DB2 pureScale environment?
What type of table can be converted into a column-organized table with the db2convert command?
What type of table can be converted into a column-organized table with the db2convert command?
Which statement regarding NOT ENFORCED unique constraints is true?
Which statement regarding NOT ENFORCED unique constraints is true?
Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?
Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?
Which scenario does NOT require intraquery parallelism?
Which scenario does NOT require intraquery parallelism?