EIQ
DS TransMon Configuration Tool Features
Creating
an EIQ DS TransMon Task
Creating
an EIQ DS TransMon Task Item
New
EIQ DS TransMon Task Item Wizard.
Microsoft
Message Queue (MSMQ) Setup page
Java
Message Queue (JMS) Setup
Controlling
EIQ DS TransMon Tasks and Task Items
EIQ
DS TransMon Task Item Status
EIQ DS TransMon Configuration Tool Features
The EIQ DS TransMon Configuration Tool is used to configure and monitor EIQ RTIS and the specified message queues. This tool provides an interface where users configure the server to monitor supported data source transaction logs for updates.
Connecting to EIQ RTIS
Connect to EIQ RTIS and a corresponding EIQ Product Server:
· Enter the IP address or computer name of the EIQ Product Server and EIQ RTIS instance.
· Click 'Connect' to continue.
Creating an EIQ DS TransMon Task
Users need to create an EIQ DS TransMon Task to monitor data source transaction logs.
To create a new EIQ DS TransMon Task, follow these steps:
· Right-click the 'Tasks' folder in the scope pane.
· Select 'New Task' from the context menu.
· Complete the steps in the 'New Task Wizard'.
New Task
Wizard
The New Task Wizard provides the interface for adding a task.
Configure
Task page
Task Name: Specifies the name of the task.
Data
Source selection page
Data Source Type: This contains a list of the supported data sources.
This page is only
displayed for Oracle data sources.
DSN: This is the name of the ODBC data source setup for Oracle.
UID: This is the user ID for the above DSN.
PWD: This is the password for the DSN.
Test Connection: This button allows you to test if the DSN has a valid connection.
This page is only
displayed for Oracle data sources.
· Select the data source name (DSN) for the data source.
· Next, enter the password for the connection if prompted.
'Test Connection' is used to test the connection for the entered DSN. However, this is not required if you clicked 'Build' and selected a valid data source. If you manually entered the data source information you may be prompted to test the connection.
· Click 'Test Connection’ to test the data source connection status.
The new task is displayed with the following format:
TASK NAME (data source type) [- ADDITIONAL INFORMATION]
The optional additional information depends on the data source type:
Oracle: TNS Service Name
SQL Server: N/A
DB2: N/A
MySQL: N/A
The red exclamation mark icon appears next to the new task. In this situation, it means a task item must be added (See below).
Creating an EIQ DS TransMon Task Item
An EIQ DS TransMon Task Item contains information regarding which data source and tables to monitor for updating the corresponding EIQ Index tables. EIQ RTIS monitors the transaction logs for updates specific to the tables selected in the task item.
To create an EIQ DS TransMon Task Item, follow these steps:
· Right-click an existing task.
· Select 'New Item' from the context menu.
· Complete the steps in the 'New EIQ DS TransMon Task Item Wizard'.
New EIQ DS TransMon Task Item Wizard
Configure
Task Item page
Task Item Name: This specifies the display name for the new task item.
Data Source Alias: This list contains a registered EIQ Server Data Source Alias. Only the data source alias for the selected data source and server instance are displayed.
Last Timestamp: The date and time fields specify the initial or last timestamp used to query the transaction logs.
Task Item Type: This list contains valid transaction layer types, such as MSMQ or JMS. These are the destination message queue types that are used with EIQ RTIS.
To change the timestamp values, select the value you want to change and click the appropriate up or down button.
Microsoft
Message Queue (MSMQ) Setup page
On this page, you specify the Microsoft Message Queue's server and queue name. The composite name is formatted SERVERNAME\QUEUENAME. The specified queue name is used by the EIQ DS TransMon Configuration Tool for this task item and must be the same as the queue name for the data source alias when configuring EIQ RTIS through the EIQ Update Configuration Tool.
Server Name: This specifies the server name for the target queue. The SERVERNAME is the server that hosts the target MSMQ queue. Specify a ‘.’ (dot) to use a local queue.
Queue Name: This specifies the queue name. The QUEUENAME specifies the target queue on the host server where the messages are sent.
Java
Message Queue (JMS) Setup
If JMS was selected as
the Task Item Type, the following page is displayed. The only difference is the
format only requires the queue name.
Queue Name: This specifies the JMS Queue's queue name that will be used by the EIQ DS TransMon Configuration Tool for this task item. The Queue Name must be formatted as QUEUENAME. The QUEUENAME must be the same as the queue name for the data source alias when configuring EIQ RTIS through the EIQ Update Configuration Tool. In the example above, the Queue Name for JMS would be POLICE. A server name is not required.
Table
Selection page
Available Tables: This list contains all available tables for the data source alias.
Selected Tables: This list contains all tables selected for the Task Item.
Note: A task item can contain one or more tables. However, multiple task items within a task should have unique tables.
Controlling EIQ DS TransMon Tasks and Task Items
Each EIQ DS TransMon Task Item can be stopped, paused, or started at any time. This is useful when debugging a specific Task Item or transaction layer.
To control the status of a specific item, follow these steps:
· Right-click the item in the scope pane.
· Select the desired task item state.
Task items are initially created in the stopped state. It must be started to monitor transaction logs.
When started, the task item icon changes to the 'Running' state.
EIQ DS
TransMon Task Item Status
EIQ DS TransMon Task items have 4 states represented by an associated scope icon.
The states are:
Running: Indicated by a green 'play'
arrow, this state means the task item is running and has no errors.
Paused: Indicated by blue 'pause' bars,
this state means the task item is running but is currently paused. EIQ RTIS
does not receive update information from the transaction layer while a task item
is paused.
Stopped:
Indicated by a red 'stop' square, this state means the task item is stopped.
EIQ RTIS does not receive update information from the transaction layer while a
task item is stopped.
Error: Indicated by a red exclamation mark,
this state means there are one or more errors with the task item. Errors can be
reviewed using the EIQ Diagnostics Tool. Task items remain running
when in the error state, but they usually do not process transaction logs.
Configuring Multiple Tasks
If you create another Oracle task that points to the same data source server instance, the following warning displays. In this case, select another data source that points to a unique server or cancel the create task operation.
