DB2

This describes the monitoring setup for the IBM DB2 database.

Prerequisite

• Database and port(50000) can be accessed by the gateway.

• SELECT and EXECUTE privileges to access the following database tables:

  • SYSIBMADM.MON_TBSP_UTILIZATION
  • SYSIBMADM.MON_DB_SUMMARY
  • SYSIBMADM.MON_BP_UTILIZATION
  • SYSIBMADM.SNAPDB

• A gateway management profile mapped to a resource.

• Create credentials with type Database before assigning a template to a resource. The Port, Connection Time-out, and Is Secure values are not used to create credentials.

Discovery using the gateway

The gateway establishes a connection to the database using the Java Database Connectivity (JDBC) Java API and collects metrics using SQL queries. To monitor DB2, install gateway version 5.5.0 or later.

Use one of the following mechanisms to discover DB2 servers to add them to your inventory:

• WMI
• SSH
• SNMP

Optionally, add a database server manually to the infrastructure inventory:

1. Select Infrastructure and click Resources.
2. Click the Settings icon on the top-right and click Add.
3. On the Add Device page, enter the Device Type and any other information you want to enter.
4. Click Save.

Prepare the device to start monitoring

• Associate appropriate database credentials to the discovered database.
• Assign one or more database-specific global monitors or templates on the device.
  Optionally, create custom metrics or monitors using SQL queries and assign them to the database.

Create custom metrics

To create a metric using SQL query for DB2 monitoring, navigate to Monitoring > Metrics > Create Metric. For example, to create a metric to find the user and system CPU time, use:

SELECT AVG_RQST_CPU_TIME / 1000 FROM SYSIBMADM.MON_DB_SUMMARY

For more information, see Create a Metric.

Assign templates from setup

Assign DB2 templates to one or more resources for a selected client and change the configuration parameters while assigning templates. For more information, see Assign Templates from Setup.

Assign templates at the device level

Applying DB2 templates at the device level helps assign one or more templates to a specific resource. You can change the configuration parameter default values while assigning the templates. For more information, see Assign Templates at the Device Level.

Resource template configuration parameters:

Assign template from device management policies

Device management policies help manage resources. You can assign monitoring templates, knowledge base articles, and custom attributes using device management policies. The device management policy can be applied to one or a set of resources. For more information, see Creating Policies.

View resource metrics

The gateway monitors the application using the assigned templates and displays the results in graphical format. To view resource metrics, click the database resource name > resource Details > Metrics.

Troubleshooting

Verify the following if the graphs are not plotted correctly:

• The resource is accessible and Telnet is established for the IP address and port.
• Valid credentials are used for the resource.

If you have DB2 monitoring issues, verify gateway and telnet connectivity:

ping <IP Address>
telnet <IP Address> <Port>

Supported templates

Supported metrics