Configure a logging task

The logging task needs run on the same image as the coordination queue manager. We can log to Db2 .

Create a logging task

Copy the PDSE to make the logger specific PDSE. For example, user.MFT.LOGGER.

For to use a different credentials file, create one. For more information, see Create an MFT credentials file.

Review member BFGCUSTM. Note that much of the content remains the same from the previous customization.

• Change //SYSEXEC DD DSN=SCEN.FTE.JCL....
• Change LIBRARY to match the agent PDSE
• Change QMGR to the name of the coordination queue manager
• Make SERVICE_TYPE=LOGGER
• Change NAME to be the name of the logger (matching the PDSE)
• Review JOBCARD and change the jobname so that the name is different from the job names of the agents.
• Review BFG_JVM_PROPERTIES="-Xmx1024M"

If we are using the Db2 logger it is useful to create a file, so that we can capture Db2 traces to help identify Db2 problems.

db2.jcc.traceDirectory=/u/johndoe/fte
db2.jcc.traceFile=jccTrace1
db2.jcc.traceFileAppend=false
# turn on all traces
# db2.jcc.traceLevel=-1
# turn off all traces
db2.jcc.traceLevel=0

BFG_JVM_PROPERTIES=-Ddb2.jcc.propertiesFile=/u/.../sql.properties
-Ddb2.jcc.ssid=DBCA

Where /u/.../sql.properties is the name of our Db2 trace properties file, and DBCA is the name of our Db2 subsystem.

Submit this job, noting that the job requires exclusive access to the data set. The jobs for the agent all have names like BFGLG*.

Logging to files

For more information on logging to Db2, see Create a logging task, when logging to Db2

Rename member BFGLGCRS. This job updates files in the Managed File Transfer (MFT) directory and uses CSQUTIL to create agent specific queues in the local queue manager.

The original file has command %BFGCMD CMD=fteCreateLogger -h which lists the syntax of the command.

To create the logger task comment out the %BFGCMD CMD=fteCreateLogger -h by putting /* in front of the statement, making sure that column one is blank.

%BFGCMD CMD=fteCreateLogger   +
-p MQPH     +
-loggerQMgr MQPH      +
-loggerType FILE        +
-fileLoggerMode circular    +
-fileSize 5MB +
-fileCount 5 +
-p MQPH +
-credentialsFile //'<MFTCredentialsDataSet(MemberName)>'
LOGGER

/u/user_ID/fte/wmqmft/mqft/config/MQPH/loggers/LOGGER/logger.properties

This is useful if we need to display properties file.

/u/user_ID/fte/wmqmft/mqft/logs/MQPH/loggers/LOGGER/

If we are logging to file, the log files are stored in this directory, for example LOGGER0-20140522123654897.log.

/u/user_ID/fte/wmqmft/mqft/logs/MQPH/loggers/LOGGER/logs

We can now start the logging task.

Create a logging task, when logging to Db2

Rename member BFGLGCRS.

This job updates files in the MFT directory and uses CSQUTIL to create agent specific queues in the local queue manager.

Edit the file. The original file has command %BFGCMD CMD=fteCreateLogger -h which lists the syntax of the command.

%BFGCMD CMD=fteCreateLogger   +
-p MQPH     +
-loggerQMgr MQPH      +
-loggerType DATABASE      +
-dbType DB2           +
-dbName DSNDBCP         +
-dbDriver /db2/db2v10/jdbc/classes/db2jcc.jar  +
-dbLib /db2/db2v10/jdbc/lib/            +
-credentialsFile //'<MFTCredentialsDataSet(MemberName)>' +
LOGGER

To create the logger task comment out the %BFGCMD CMD=fteCreateLogger -h by putting /* in front of the statement, making sure that column one is blank.

/u/user_ID/fte/wmqmft/mqft/config/MQPH/loggers/LOGGER/logger.properties into member USS

This is useful if we need to display the properties file

/u/user_ID/fte/wmqmft/mqft/logs/MQPH/loggers/LOGGER/logs

Create Db2 tables

We need to create the Db2 tables. The definitions are in the USS file mqft/sql/ftelog_tables_zos.sql.

Create a member Db2 in your PDSE. Edit this member and use the COPY command on the command line. Copy from the USS definitions file.

Because site-specific requirements can vary greatly, this file only specifies the basic structures of the tables, and a table space where they will be located.

The table space is specified, by the SQL script, to ensure that it is created using a buffer pool with a page size sufficient to hold the largest tables rows possible. Note that attributes such as LOB locations, and so on, are not specified.

Your database administrator might want to modify a copy of this file, to define these performance-related attributes.

This file also assumes a default schema name of FTELOG, default tablespace name of FTELOGTS, and database name of FTELOGDB. We can change these names if we need, to match an existing database and any local naming conventions, by following the process described in the comments at the beginning of the file.

Starting the logger task

Rename, review and submit the member BFGLGST We should get the message BFGDB0023I: The logger has completed startup activities and is now running.

Logger operations

To display the logger status, Rename, review, and submit member BFGLGSH

To stop the logger, Rename, review, and submit member BFGLGSP.