DB2 10 for z/OS Database Administrator — Question 53

Which statement about Data Server Manager (DSM) is TRUE?

Answer options

• A. DSM can be used for reviewing audit trails
• B. DSM cannot be used for database administration
• C. DSM can be used for configuration management of DB2 Data Server drivers
• D. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

Correct answer: D

Explanation

The correct answer is D because Data Server Manager is specifically designed to monitor and analyze performance issues, providing tools to address them. Option A is incorrect as while DSM may help with audit trails, it is not its primary function. Option B is false as DSM does have capabilities for database administration. Option C is partially correct but does not capture the full scope of DSM's functionality.