DB2 10 for z/OS Database Administrator — Question 10

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

Answer options

• A. SELECT tbsp_name, tbsp_utilization_percent FROM TABLE(sysproc.mon_tbsp_utilization()) AS t WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 1;
• B. SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 0;
• C. SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 1;
• D. SELECT tbsp_name, tbsp_utilization_percent FROM sysibmadm.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95

Correct answer: C

Explanation

The correct answer is C because it selects table spaces with utilization over 95% and checks if auto-resize is enabled, indicating they might fill up. Option A incorrectly requires auto-resize to be enabled, which is not suitable for identifying risks of filling. Option B looks for spaces with auto-resize disabled, making it less relevant, while D does not consider auto-resize at all.