What data can provide information to allow for a priority list of candidate table spaces for reorganization ba
The available window to reorganize table spaces is being reduced. What data can provide
information to allow for a priority list of candidate table spaces for reorganization based on recent
activity with no recent RUNSTATS execution?
Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?
Which DB2 trace is utilized to capture overall subsystem virtual memory consumption?
What is a consideration when specifying DATA CAPTURE CHANGES?
What is a consideration when specifying DATA CAPTURE CHANGES?
what storage space requirement should be of carefully monitored?
In using plan stability, what storage space requirement should be of carefully monitored?
What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the cache?
What two parameters allow DB2 to keep a copy of a dynamically prepared statement in the
cache?
What START TRACE command provides detailed lock suspend and lock contention trace information?
What START TRACE command provides detailed lock suspend and lock contention trace
information?
which statement is correct?
When converting a multiple table segmented table space to partition-by-growth table spaces,
which statement is correct?
What would be a reason for altering the clustering index of a table?
What would be a reason for altering the clustering index of a table?
What is the DSNZPARM that determines the maximum amount of temporary storage in the work file data base for a
What is the DSNZPARM that determines the maximum amount of temporary storage in the work
file data base for a single user at any given time?
what is the purpose of the PREFLIST?
In the CFRM policy, what is the purpose of the PREFLIST?