This section describes the required configurations as well as the optional configurations available for the Solution Package for IBM DB2 in the RTView Configuration Application. You must define the classpath to the IBM DB2 jar files and you must also define data source connections for each connection that you want to monitor. 

Configuring Data Connection

Use the RTView Configuration Application to configure your data collection.

• Navigate to Solution Package Configuration > IBM DB2 from the list.

• On the CONNECTIONS tab, provide the correct full path to the directory containing the IBM DB2 jar files in the Classpath field.
• In the Connections region, click the  icon.

The Add Connection dialog displays.

• Specify the connection information and click SAVE where:

Connection Name: Enter the desired name for the connection.

Database URL: Enter the complete URL for the database connection. For example: jdbc:db2://hostOrIP>:50001/databaseName

Username: The username is used when creating the connection to the database. This field is optional.

Password: This password is used when creating the connection to the database. This field is optional. By default, the password entered is hidden. Click the  icon to view the password text.

The newly created connection displays in the Connections section.

• You can optionally modify the Poll Rates (query interval, in seconds) that will be used to collect the metric data for the Poll Rate (Db2EnvSysResources, Db2SnapDbm, Db2SnapDb, Db2DbSummary, and Db2TimeSpent caches) and the  Poll Rate Large (Db2BufferPools, Db2TableSpace, Db2PdLogMsgs, and Db2SnapSwitches caches) caches by clicking on the DATA COLLECTION tab and entering the desired polling rate for each cache.