Retrieving IBM DB2 Performance Metrics

Establish a connection to a data source to monitor IBM DB2 DBMS systems and to create an initial view that contains the measures you want to monitor.

  1. On the Real-Time Monitoring tab, in the Monitor group, click System. The Data Source wizard opens.
  2. Click the Select from predefined Data Sources option button.
  3. Click Next. The System selection page opens.
  4. Expand the Database System folder and select IBM Universal Database DB2 (snapshot dll).
  5. Click Next.

    The Connection parameters page opens.

  6. In the Hostname text box, specify the host on which the DB2 database is running.
  7. Click Next. The Attributes Configuration page opens.
  8. Define the following monitoring-specific attributes:
    • Alias – The database alias is used by the monitoring project in the following DB2-specific command: "connect to 'alias' user 'user' using 'password'".
    • Instance – The instance name is used by the monitoring project for executing the following DB2-specific command: "attach to 'Instance' user 'user' using 'password'".
    • User – Specify a user with the following DB2 authorizations:
      • sysadm
      • sysctrl
      • sysmaint
    • Password – The password for the user.
  9. Click OK. The Select displayed measures page opens.
  10. Check the check boxes for those measures that you want to include in the initial monitor view and then click Finish.
A connection to the specified host is established, and an initial view that contains the measures you selected is displayed.
Parent topic: IBM DB2 Performance Monitoring