Configuring the iWay Log Event Listener

How to:

iWay Log Event Listener captures the changed data by reading transaction records directly from redo and archived log files.


Top of page

x
Procedure: How to Configure the iWay Log Event Listener

To configure the iWay Log Event Listener using the iWay Service Manager Administration Console:

  1. From the Windows Start menu select All Programs, iWay 6.0 Service Manager, and then Console.

  2. Click Registry in the top pane.

  3. In the left pane, select Listeners.

    The Listeners pane opens, as shown in the following image.

    The table that is provided lists existing listeners and a short description for each.

  4. Click Add.

    The Listener Type pane opens.

  5. Select the OracleLEA from the Type drop-down list and click Next.

    The configuration parameters pane for the iWay Log Event Listener opens.

  6. Provide the required configuration parameters for the new listener, which are described in iWay Log Event Listener Configuration Parameters.
  7. Click Next.

    The Name and Description pane opens.

  8. In the Name field, type a name to identify the iWay Log Event Listener (for example, LogEvent_Listener).
  9. In the Description field, type an optional description for the iWay Log Event Listener.
  10. Click Finish.

    The new File listener (LogEvent_Listener) is added to the list in the Listeners pane.


Top of page

x
Reference: iWay Log Event Listener Configuration Parameters

Parameter

Description

JNDI Name

JNDI name for the requested data source. To use an iWay JDBC provider, specify as jdbc/provider. Required if using JNDI.

URL

URL for JDBC driver to access the database.

DBA User Name

Database user to access table.

DBA Password

Database password.

Schema Table Filter *

List all the schemas with tables separated by using a comma (for example: scott.classes,scott.emp,store.temp,...)

Dictionary Location *

Dictionary location (for example: /usr/tmp/logmine/).

Oracle Dictionary Filename *

Oracle dictionary file name (for example: dictionary.ora).

Marker Property File *

The location of the marker property file.

The marker property file is used by the Oracle LEA Listener to store state and debug information between polls. If the Log Last Executed Transactions parameter is set to true for the listener, then the XML representing the list of transaction processed during the last poll will be written to the marker property file. This is useful for debugging purposes, but should be set to false for a production environment.

In addition, the Oracle last system change number (SCN) used to retrieve transactions is written to the property LAST_EXECUTION_LSN_NO in the marker property file. This number can be modified to retrieve a previous transaction or to skip a transaction in the sequence.

Redo logs Duration *

Redo to be read from Logs starting from number of hours. One hour is the default value.

Redo Log Archive Directory Filter

Location of Redo Log Archive Directory Filter (for example: /rdbms/ora102/archive2).

Log Last Executed Transactions

Controls whether or not the transaction XML is logged to the marker file. This parameter is useful for debugging purposes, but should be set to false for production environments.

LogMiner Options *

Determines whether the Oracle LogMiner tracks uncommitted changes. The default value is 1.

Whitespace Normalization

Specifies how the parser treats whitespace in Element content. Choose preserve (default) to turn off all normalization as prescribed by the XML Specification. Choose condense to remove extra whitespace in pretty printed documents and for compatibility with earlier versions.

Optimize Favoring

Selection of memory is useful for large input documents.

Execution Time Limit

Time limit for document execution (in seconds) before it is cancellation is attempted.

Polling Interval

Interval at which to check for new input. By default, the interval is 2.0.

Default Java File Encoding

Default encoding if incoming message is not self-declaring (for example, XML). By default, Cp1252 is selected.

Agent Precedence

Changes order by which engine selects agents. Normally Document overrides listener. This is used to manage iWay documents. By default <document> overrides <listener> {1} is selected

Error Documents treated normally

If set to true, error documents will get processed by any configured pre-emitters. This parameter is set to false by default.

Record in Activity Log(s)

If set to true, activity on this channel will be recorded in the activity logs, else the activity will not be recorded.


iWay Software