which statistics should NOT be considered?
For monitoring space growth over time, which statistics should NOT be considered?
Which statement is NOT true?
Which statement is NOT true?
Which one of the following statements is true about this recovery situation?
The billing application has a DB2 referential integrity set of three tables. TABA, TABB and TABC.
Daily, Full Image copies are done for the three table spaces related to the three tables. There is a
requirement to recover the three table spaces to noon time, which is about 8 hours after the full
image copies were run. Which one of the following statements is true about this recovery
situation?
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
which two of the following columns would NOT be needed?
In determining whether a REORG on an index space would improve performance, which two of
the following columns would NOT be needed? (Choose two.)
Which statistic should you monitor from the statistics report to be sure this is not occurring?
Poorly tuned memory can affect application performance, such as having sequential prefetch
turned off. Which statistic should you monitor from the statistics report to be sure this is not
occurring?
which action should be performed but will avoid using excessive CPU resources to gather the information?
In order to properly monitor locks on a continual basis, which action should be performed but will
avoid using excessive CPU resources to gather the information?
What START TRACE command should be used to gather the I/O information needed for the objects in database NEWBI
The I/O patterns for objects in database NEWBILL need to be reviewed in detail. All of the
NEWBILL work runs under a single plan, NEWBILLPL. What START TRACE command should be
used to gather the I/O information needed for the objects in database NEWBILL?
Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?
Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?
which utility can be used to provide information on space saved and potential buffer space wasted for each of
When determining what page size will be best for index compression, which utility can be used to
provide information on space saved and potential buffer space wasted for each of the different
page sizes?