Examice

Exam C2090-600 All QuestionsBrowse all questions from this exam

Question 20

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

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;

SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 0;

SELECT tbsp_name, tbsp_utilization_percent FROM syscat.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95 AND tbsp_auto_resize_enabled = 1;

SELECT tbsp_name, tbsp_utilization_percent FROM sysibmadm.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95

Correct Answer: D

The correct SQL statement to list table spaces whose utilization is greater than 95% is 'SELECT tbsp_name, tbsp_utilization_percent FROM sysibmadm.mon_tbsp_utilization WHERE tbsp_utilization_percent > 95'. This query references the sysibmadm.mon_tbsp_utilization view, which is the correct catalog view for monitoring tablespace utilization, and ensures the condition is checking for tablespaces with utilization above 95%.

Discussion

db2testerOption: D

The answer C is wrong. If you run the query, you will get the error : SQL0204N "SYSCAT.MON_TBSP_UTILIZATION" is an undefined name. SQLSTATE=42704. The correct answer is D (SYSIBMADM.MON_TBSP_UTILIZATION)