Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > Use newer DB2 polling tables

Use newer DB2 polling tables

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 80 Votes: 0 Revisions: 9

 

This article applies to DPA 9.0 and later and DB2 9.5 and later.

In DB2 version 10.5, IBM removed certain snapshot tables that were used by the "quick poll" job. In order to support DB2 10.5, it was necessary to rewrite the query to use newer snapshot tables. In doing so, we were able to make the query slightly more efficient. By default, DB2 10.5 will be monitored using the new, more efficient, snapshots.

If you are monitoring a database that is running version DB2 9.5 to 10.1, you can configure monitoring to use the new queries. Below are the steps needed to set up this configuration.

  1. Stop all DB2 Monitor(s) that you are planning to configure.

  2. Find the monitored database id by looking in the COND table:
    SELECT id, name
    FROM COND
    ORDER BY name;

  3. Add the DB2_USE_NEW_QUICKPOLL_QUERY parameter for each monitored database you plan to configure by running the following in your Repository database (replace '?' with the database ID from step 2):
    insert into CONDPRM
    values (?, 'DB2_USE_NEW_QUICKPOLL_QUERY', 'true', 'use new quick poll');

  4. Convert the CONEV_MAP_X VID column to use a string rather than an int by running the following queries (replace 'X' with the database ID from step 2):
    delete from CONEV_MAP_X;
    insert into CONEV_MAP_X (VID, ID) select NAME, ID from CONEV_X;

  5. Refresh the parameter cache:
    • Go to the "Options" page
    • Click the "Support" tab
    • Click "Refresh Parameter Cache"

  6. Restart any DB2 Monitor(s) that you configured.
Last modified

Tags

Classifications

Public