Configuring a WebSphere MQ File Transfer Edition logger

When WebSphere® MQ File Transfer Edition transfers files, it publishes information about its actions to a topic on the coordination queue manager. The database logger is an optional component of WebSphere MQ File Transfer Edition that you can use to copy this information into a database for analysis and auditing purposes.

There are two versions of the database logger: a stand-alone Java™ Platform, Standard Edition (JSE) application and a Java Platform, Enterprise Edition (JEE) application. In this documentation the two versions are referred to as the stand-alone database logger and the JEE database logger.

Stand-alone database logger

The stand-alone database logger is a Java application that you install on a system that hosts the coordination queue manager and the database. The stand-alone database logger connects to the coordination queue manager using WebSphere MQ bindings, and to a DB2® or Oracle database using the type 2 JDBC driver. This type of connection is required because the stand-alone database logger uses the queue manager's XA support to coordinate a global transaction over both the queue manager and database, protecting the data.

If you are using a Windows system, you can run the stand-alone loggers as Windows services to ensure that the loggers continue running when you log off from your Windows session. For instructions, see Installing the WebSphere MQ File Transfer Edition stand-alone database logger.

JEE database logger

The JEE database logger is provided as an EAR file, which you install into an application server. This can be more convenient than using the stand-alone database logger if you have an existing JEE application server environment available because the JEE database logger can be managed alongside your other enterprise applications. You can also install the JEE database logger on a separate system to the systems hosting your WebSphere MQ server and database. The JEE database logger is supported for use with Db2 and Oracle databases. The JEE database logger also supports Oracle Real Application Clusters when installed on WebSphere Application Server Version 7.0.


Concept Concept

Feedback

Timestamp icon Last updated: Tuesday, 30 January 2018
http://www.ibm.com/support/knowledgecenter/SSEP7X_7.0.4/com.ibm.wmqfte.doc/database_logger.htm