Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Register a database instance for monitoring > Register a DB2 database

Register a DB2 database

Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 70 Votes: 0 Revisions: 3

To register a DB2 database for DPA to monitor:

  1. On the DPA home page, click Register DB Instance for Monitoring.
  2. Under Self-Managed, click DB2 UDB.
  3. Click Next.

DB2 configuration settings

SolarWinds DPA requires the DB2 instance-wide parameter {DFT_MON_STMT} to be turned on to collect monitoring data. Follow the on-screen instructions to check and set the parameter.

If {DFT_MON_STMT} is set to OFF, you can use SolarWinds DPA to register the database instance. Later, you can set it to ON and restart the database instance during an approved maintenance window. In the meantime, the database shows a status of Idle.

Enter connection information

DB2 connection information

For the DB2 server, enter the host name or IP address and port. The default port is 50000.

Enter the DB2 database for SolarWinds DPA to monitor in the Database field. SolarWinds DPA collects information from all DB2 instances in a cluster configuration for the specified database.

If the connection information changes for the DB2 server, all databases on that instance must be updated separately through the Update Database Instance Connection Wizard.

SolarWinds DPA can monitor all databases in the specified instance, or an individual database.

  • SolarWinds DPA 9.0 and later monitors all DB2 databases in the specified instance.
  • Do you want to monitor a single database in an earlier version of SolarWinds DPA? See Switch to DB2 instance-wide monitoring.
  • To monitor a single database, each database must be registered separately through this wizard, even if multiple databases are contained on a single DB2 server instance.
  • For instance-wide monitoring, one database must be registered for the SolarWinds DPA connection.

DB2 user information

Enter SYSADM credentials for SolarWinds DPA to monitor the database instance.

Do you want more information on the DB2 permissions needed by SolarWinds DPA for the monitoring user? See Required DB2 permissions needed by DPA for monitoring.

Oracle repository tablespace

If your repository database is not Oracle, the wizard skips this step.

Choose the tablespace in the repository database to store DPA performance data for this monitored instance.

By default, the performance data is stored in the default tablespace of the repository user. However, data for monitored instances can be stored in separate tablespaces.

Select the Alert Groups

If you have no Alert Groups set up, or if this new database instance does not match the database type of the Alert Group, the wizard skips this step.

Alert Groups simplify alert configuration and help make alerting more consistent across the monitored database instances.

Select the Alert Groups you want the new database instance to join.


  1. Confirm the registration information, and click Register Database Instance.
  2. Click Finish to go to the DPA home page, or click Register Another Database Instance to continue registering.
Last modified
14:06, 15 Sep 2016