Which of the following results in improving performance of a load job to load data into an indexed partitioned table space with multiple indexes?
A table space is in AREO*. What does this status mean?
For monitoring space growth over time, which statistics should NOT be considered?
Which statement is NOT true?
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?
Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is correct?