Build the Process Tracker URL

Update the workbench object Tracker URL Lookup Table with a Process Tracker URL that is appropriate for your system.

Procedure

  1. Log on to IBM® Cognos® Real-time Monitoring Workbench.
  2. Click the Workbench tab.
  3. Expand the IBM Content Cortex Case Monitor > Examples > Threshold Monitoring folder and select Tracker URL Lookup Table.
  4. Click Edit.
  5. Use the following examples to create the appropriate JDBC query for your database type.
    Modify the following items in the examples:
    • host
    • port
    • webapp
    Table 1. JDBC query command
    Database type JDBC query
    Db2® 
    select 1 as URL_KEY,
 'http://host:port/webapp/eprocess/WcmTracker.jsp?' 
  as URL_BASE FROM SYSIBM.SYSDUMMY1
    Microsoft SQL Server 
    select 1 as URL_KEY,
 'http://host:port/webapp/eprocess/WcmTracker.jsp?' 
  as URL_BASE
    Oracle Database 
    select 1 as URL_KEY,
 'http://host:port/webapp/eprocess/WcmTracker.jsp?' 
  as as URL_BASE FROM DUAL
  6. Click Save.