1.
DB2 workfiles are critical to performance of applications. Which of the following will NOT assist with achieving best performance for workfile usage?
2.
Unnecessary REORGs of indexes may be avoided by which of the following?
3.
Which of the following utilities is NOT relevant for health checking the DB2 V10 catalog or directory in new function mode?
4.
The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANGE with utilid REORGON. Which statement is NOT true?
5.
Using the -SET LOG command, what logging characteristics CANNOT be modified?
6.
In a data sharing environment, how is the LRSN value created?
7.
What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?
8.
An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?
9.
When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose
two.)
10.
For monitoring space growth over time, which statistics should NOT be considered?