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?
which tool?
The event monitor for transactions has been replaced in DB2 9.7 with which tool?
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?
Which two DB2 commands are used to extract, format, and present diagnostic information?
Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose
two.)
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?
Which two SOL statements are explainable statements?
Which two SOL statements are explainable statements? (Choose two.)
Which method may be used to collect deadlock information in DB2 9.7?
Which method may be used to collect deadlock information in DB2 9.7?
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 DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic S
Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables,
and dynamic SQL?
Which statement regarding NOT ENFORCED unique constraints is true?
Which statement regarding NOT ENFORCED unique constraints is true?