Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the d
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not
enforced by the database manager?
Which action should be performed to improve query performance?
Which procedure is used to Explain an SQL statement using information obtained from the package cache or the p
Which procedure is used to Explain an SQL statement using information obtained from the
package cache or the package cache event monitor?
Which statement about the initiation of parallel I/O is correct?
Which statement about the initiation of parallel I/O is correct?
Which two database configuration parameter settings should be checked?
The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):
MESSAGE : ADM5502W The escalation of “28581” locks on table “TEST.TABLE1” to lock intent
“X” was successful. Which two database configuration parameter settings should be checked?
(Choose two.)
Which indexes should be created for optimal query performance?
What will occur when a database administrator adds a new automatic storage path to an existing storage group?
What will occur when a database administrator adds a new automatic storage path to an existing
storage group?
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?