Configuring DB2 environment using JDBC

Follow the steps to configure DB2 environment using JDBC connection. This will monitor only one database without its instances.

To configure DB2 environment using JDBC connection

1. From the PATROL Console work area, right-click the DB2_MAIN application class.
2. Select KM Commands > Register DB2 Monitoring > DB2 Database.
3. In the Register JDBC DB2 Database dialog box, perform the following actions:
   1. To add a new environment, enter a unique environment name for monitoring the DB2 databases. A container will be created with the environment name. This environment will hold all the DB2 databases. BMC recommends you to provide only alphanumeric characters in environment name.
   2. To add new remote database connection details, enter the following:
      1. DB Host - Enter the name of the databases. BMC recommends you to provide only alphanumeric characters in database name.Enter the database hostname or an IP address.
      2. DB Port - Enter the database port number. Default port number is 50000.
      3. DB User - Enter the name of the user with permissions to connect and run SQL queries on the DB2 database. The user should have minimum SYSMON authority with DATAACCESS privileges.
      4. DB Password - The password of the DB2 user.
      5. DB2 Name - Enter the name of the databases. BMC recommends you to provide only alphanumeric characters in database name.
   3. To add JAVA collector details, enter the following:
      1. JAVA_HOME -
         • Enter the full path (do not use the short path format) to the JRE directory on the PATROL Agent host. The Java version must be 8 or later.
           For example:
           • Windows: C:\Program Files (x86)\Java\jre8
           • Unix\LINUX: /usr/java8_64
         • Alternatively, you can also use the $JAVA_HOME environment variable in this field. If you use the $JAVA_HOME variable, the Java location depends on the $JAVA_HOME you declare in you PATROL agent host.
         • If this field is left blank, the KM looks for the Java executable in the Patrol3\openjdk and Patrol3\jre64 locations.

      2. Executing user - Enter the name of the OS JVM user (this user must exist where the PATROL Agent and DB2 KM are installed) with permission to run the Java process.

         Note: If this field is left blank, the KM will use the user that is running the PATROL Agent.

      3. Password - The password of the OS JVM user.
   4. Click OK to apply the configuration.
   5. Click Cancel to close the dialog box.