Multiple choice technology databases

which of the following tools is used to analyze all of the database operations by an application against a DB2 for i5/OS database?

  1. Visual Explain

  2. Activity Monitor

  3. SQL Performance Monitor

  4. DB2 Performance Monitor
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Performance Monitor is the tool specifically designed for analyzing database operations against DB2 for i5/OS. Visual Explain shows access plans. Activity Monitor is for real-time monitoring. DB2 Performance Monitor was the tool for other DB2 platforms, not i5/OS.

Keep practicing — related questions