Configuring the database logger for use with the Web Gateway

To be able to query the status of transfers and the contents of file spaces you must have a WebSphere® MQ File Transfer Edition Version 7.0.3, or later, database logger in your WebSphere MQ File Transfer Edition network and a database that contains the Version 7.0.3, or later, tables.

About this task

The following example shows the result of requesting the status of a transfer when the database logger is not correctly configured:
  1. This HTTP request submits a transfer query:
    GET HTTP/1.1 /transfer/414d51204d554e474f2afed834435bc6edaf323520204cee
    Host: example.com
    User-Agent: mozilla
  2. The Web Gateway returns an HTTP response with the following format:
    HTTP/1.1 500 Internal Server Error
    Server: WAS/6.0
    Content-length: 93
    Content-type: text/plain
    
    BFGWI0018E: The request could not be completed due to an internal 
    web application server error.

To configure the database logger so that the request is processed correctly, perform the following steps:

Procedure

  1. Install the WebSphere MQ File Transfer Edition Version 7.0.3, or later, database logger. This is located on the Remote Tools and Documentation install DVD. For more information on how to install and configure the database logger, see Configuring a WebSphere MQ File Transfer Edition logger.
  2. If you already have the WebSphere MQ File Transfer Edition Version 7.0.3, or later, database logger installed, ensure that your database tables are up to date. Use the SQL files provided in the following directories to update your database tables:
    • On distributed platforms: <install_directory>/tools/sql
    • On z/OS®: <install_directory>/sql

Task Task

Feedback

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