Enable the JDBC agents

To access the Case Analyzer store, enable the appropriate Java Database Connectivity (JDBC) agents for the type of data that you plan to monitor.

About this task

The following JDBC agents are used to query the Case Analyzer store.
CADB_JDBC_Agent
This agent queries the current work in progress data.
CADB_NearTerm_JDBC_Agent
This agent queries the historical data for the current quarter. Each query scans 20,000 rows in the database.
CADB_Dimensions_JDBC_Agent
This agent queries common dimensions for both current and recent historical monitoring. This agent is enabled by default.
CADB_Threshold_JDBC_Agent
This agent queries for data that have triggered alerts or have exceeded a specified threshold.

You can enable the specific JDBC agents according to the type of data that you want monitored. Only the CADB_Dimensions_JDBC_Agent agent is enabled by default.

Procedure

To enable a JDBC agent:

  1. Open IBM® Cognos® Real-time Monitoring Workbench.
  2. Navigate to the appropriate folder to enable the JDBC agent that you want to use.
    If the JDBC agent you want to enable is... Then navigate to...
    CADB_JDBC_Agent
    CADB_NearTerm_JDBC_Agent
    		 IBM Content Cortex Case Monitor\Common
    CADB_Dimensions_JDBC_Agent IBM Content Cortex Case Monitor\Common\Dimensions
    CADB_Threshold_JDBC_Agent IBM Content Cortex Case Monitor\Example\Threshold
  3. Select the agent.
  4. Click Enable.
  5. Choose the Enable All option.