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.)
Consider the following statement: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?
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 constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
