Which DB2 performance feature is designed specifically to reduce the number of indexes that
need to be created?

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 are VPSIZE 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?

The new billing application is seeing Class 2 Elapsed Time being made up of mainly Class 3
Synchronous database I/O time. All of the DB2 objects for the new billing application are in BP5.
What command can be used to research the details behind the database I/O time associated with
the new billing application?

Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL
statement cache?

What must be in place for the support of index compression?

How do you enable parallelism in a dynamic SQL statement?

Which DB2 trace has potentially the highest level of overhead, and should typically be run in
specific situations and only for short durations?

When is changing an index from non-clustering to clustering NOT allowed?

To monitor the storage used above and below the 2GB bar, what must occur?