MQ MFT Statistics Table (MQ_STATS_LOG)

ACTION

varchar

MQ FTE action type. The values are started, progress, or completed.

ACTION_TIME

varchar

Action time. The format is yyyy-mm-ssThh:mm:ss.nnnZ.

AGENTROLE

varchar

Agent role, for example, sourceAgent or destinationAgent.

CALL_CMD_ARGUMENT

varchar

The call command arguments.

CALL_CMD_NAME

varchar

The call command name.

CALL_CMD_RETRYCOUNT

varchar

The call retry count.

CALL_CMD_RETRYWAIT

varchar

The call retry wait time.

CALL_CMD_SUCCESSRC

varchar

The call specification of a successful RC.

CALL_CMD_TYPE

varchar

The call command type.

CALL_CRSLT_OC

varchar

The outcome of the call.

CALL_CRSLT_RETRIES

varchar

The number of retries for the call.

CALL_CRSLT_RSLT_ERROR

varchar

The call resulting error.

CALL_CRSLT_RSLT_OC

varchar

The call resulting outcome.

CALL_CRSLT_RSLT_RC

bigint

The call resulting return code.

CALL_CRSLT_RSLT_STDERR

varchar

The call stderr output.

CALL_CRSLT_RSLT_STDOUT

varchar

The call stdout output.

CALL_CRSLT_RSLT_TIME

varchar

The call result time.

DESTAGENT_AGENT

varchar

Name of the destination agent.

DESTAGENT_QMGR

varchar

Name of the destination agent queue manager.

DESTAGENT_SYSTEMINFO_ARCH

varchar

Architecture of the destination agent.

DESTAGENT_SYSTEMINFO_NAME

varchar

Name of the destination agent operating system.

DESTAGENT_SYSTEMINFO_VER

varchar

Version of the destination agent operating system.

EVENT_ID

bigint

ID number assigned by the system to each event.

ID

varchar

MQ MFT identifier for the file transfer.

JOB_NAME

varchar

Job name (if provided). Otherwise, the value isMQ MFT_transfer.

LOG_DATE_TIME

varchar

Date and time the statistics record was generated. The format is yyyymmdd hh:mm:ss.nnn.

METADATA

varchar

User metadata. Format is [key1=value1].[key2=value2]...

ORIGINATOR_HOSTNAME

varchar

Hostname of the request originator.

ORIGINATOR_MQMDUSERID

varchar

MQMD userid of the originator.

ORIGINATOR_USERID

varchar

Originator userid.

PART_KEY

date

Date the statistics record was generated. The format is yyyy-mm-dd

SRCAGENT_AGENT

varchar

Name of the source agent.

SRCAGENT_QMGR

varchar

Name of the source agent queue manager.

SRCAGENT_SYSTEMINFO_ARCH

varchar

Architecture of the source agent.

SRCAGENT_SYSTEMINFO_NAME

varchar

Name of the source agent operating system.

SRCAGENT_SYSTEMINFO_VER

varchar

Version of the source agent operating system.

STATISTICS_ACTUALSTARTTIME

varchar

Action start time for the statistics.

STATISTICS_NUMFILEFAILURES

bigint

Number of file failures.

STATISTICS_NUMFILEWARNINGS

bigint

Number of file warnings.

STATISTICS_RETRYCOUNT

bigint

Number of retires.

STATUS_RESULTCODE

varchar

Result code.

STATUS_SUPPLEMENT

varchar

Supplement message.

TS_INDEX

bigint

Transfer set index.

TS_ITEM_DEST_CS

varchar

Destination file checksum.

TS_ITEM_DEST_CS_METH

varchar

Destination file checksum method.

TS_ITEM_DEST_EXIST

varchar

The exists= specification.

TS_ITEM_DEST_FILE

varchar

Destination filename.

TS_ITEM_DEST_LMOD

varchar

Last modified date/time of the destination file. The format is yyyy-mm-ssThh:mm:ss.nnnZ.

TS_ITEM_DEST_Q_GROUPID

varchar

Destination queue group ID.

TS_ITEM_DEST_Q_MSGCOUNT

bigint

Count of messages to queue.

TS_ITEM_DEST_Q_MSGID

varchar

Destination queue message ID.

TS_ITEM_DEST_Q_MSGLENGTH

bigint

Length of message.

TS_ITEM_DEST_SIZE

bigint

Destination file size.

TS_ITEM_MODE

varchar

File mode, for example, binary.

TS_ITEM_SRC_CS

varchar

Source file checksum.

TS_ITEM_SRC_CS_METH

varchar

Source file checksum method.

TS_ITEM_SRC_DISP

varchar

Source file disposition.

TS_ITEM_SRC_FILE

varchar

Source filename.

TS_ITEM_SRC_LMOD

varchar

Last modified date and time of the source file. The format is yyyy-mm-ssThh:mm:ss.nnnZ.

TS_ITEM_SRC_Q_GROUPID

varchar

Source queue group id.

TS_ITEM_SRC_Q_MSGCOUNT

bigint

Count of messages to queue.

TS_ITEM_SRC_Q_MSGID

varchar

Source queue message id.

TS_ITEM_SRC_Q_MSGLENGTH

bigint

Length of message.

TS_ITEM_SRC_SIZE

bigint

Source file size.

TS_ITEM_STATUS_RSLTCODE

varchar

Result code for the transfer.

TS_ITEM_STATUS_SUPPLEMENT

varchar

The supplement message for the transfer.

TS_ITEM_STATUS_SUPPLEMENT_ID

varchar

The supplement message id for the transfer.

TS_SIZE

bigint

Size of the transfer set.

TS_STARTTIME

varchar

Start date and time of the transfer. The format is yyyy-mm-ssThh:mm:ss.nnnZ.

TS_TIME

varchar

The time of the transfer.

TS_TOTAL

bigint

Total number of files transferred in this request.

VER

varchar

Transaction version.