Verifying integration of OMEGAMON and Db2 Query Monitor

After you enable Db2 Query Monitor in the OMEGAMON® enhanced 3270 user interface, follow the procedure to verify that the integration was successful.

Procedure

  1. Log in to the E3270UI.
  2. From the Hub Connectivity Administration workspace, locate and select the Hub TEMS that the CAE Server is connected to.
  3. Select the DB2 tab on the OMEGAMON Products panel.
  4. Type T next to the Db2 ID.
  5. Select any active thread.
  6. Select the Acct tab. If Db2 Query Monitor is successfully integrated, you will see a Current SQL Activity Details section that includes an Active SQL Count field. The data in this section is provided by Db2 Query Monitor.
  7. To view more detailed information, double-click inside the Active SQL Count field (or select the field and press Enter).
    Note: If the name of the panel under the Command line begins with KQQ, this indicates that the data is retrieved from Db2 Query Monitor.