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?
