Update the workbench object Tracker URL Lookup Table with a Process
Tracker URL that is appropriate for your system.
Procedure
- Log on to IBM®
Cognos® Real-time Monitoring Workbench.
- Click the Workbench tab.
- Expand the folder and select Tracker URL Lookup Table.
- Click Edit.
- 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 commandDatabase 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
|
- Click Save.