Start of change,             

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 FileNet® 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 (Substitute either Workplace or Workplace XT.)
    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.


Last updated: October 2015
adv_example_tracker_1.htm

© Copyright IBM Corporation 2015.
End of change