Which of the items listed below is NOT a prerequisite for using CURRENT EXPLAIN MODE?
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?
Which DB2 performance feature is designed specifically to reduce the number of indexes that need to be created?
In using plan stability, what storage space requirement should be of carefully monitored?
The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available areVPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of 14.6 seconds, what should be done to increase page residency time?
What WLM action will establish performance objectives for DDF threads and their related address space?
