MQ MFT virtual statistics table (V_MQ_STATS_LOG)

The following table describes the data fields available from the MQ MFT Virtual Statistics (V_MQ_STATS_LOG) table for IBM® Sterling Control Center Monitor reports:

Element	Type	Description
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.
DEST_FILE	varchar	Destination file name in a copy operation.
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.
EVENT_TYPE	bigint	Code indicating the type of event.
FILE_SIZE	bigint	Size of the file transferred by the Sterling Connect:Direct Process or Sterling Connect:Enterprise batch.
FROM_NODE	varchar	Server that sent the file. P=Pnode was sending server. S=Snode was sending server.
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]...
MSG_ID	varchar	Server or IBM Sterling Control Center Monitor message ID issued with the event.
NODE_ID	varchar	Server name of alias.
NODE_TYPE	varchar	Code indicating the type of server. The server types are: 0=IBM Sterling Control Center Monitorr 1=Sterling Connect:Direct 2=Sterling Connect:Enterprise 3=Sterling B2B Integrator 4=FTP Server 5=Sterling Connect:Express 7=MQ MFT
ORIG_NODE	varchar	The server that initiated the Process.
ORIGINATOR_HOSTNAME	varchar	Hostname of the request originator.
ORIGINATOR_MQMDUSERID	varchar	MQMD userid of the originator.
ORIGINATOR_USERID	varchar	Originator userid.
PROC_ID	varchar	Sterling Connect:Direct Process or Sterling Connect:Enterprise batch number.
PROC_NAME	varchar	Sterling Connect:Direct Process name or Sterling Connect:Enterprise batch name.
REMOTE_NODE	varchar	Name of the remote server involved in the Process or file transfer.
RET_CODE	varchar	Specifies a numeric code returned from a completed Process or file transfer that indicates failure or success. The standard return codes are: 0=Successful completion 4=Warning 8=Error 16=Catastrophic error
SEQ_NUM	bigint	A number used to uniquely identify events generated at the same time.
SHORT_MSG	varchar	Message text associated with the Message ID.
SOURCE_FILE	varchar	Source file name in a copy.
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.
STEP_NAME	varchar	Name of the Sterling Connect:Direct Process step.
SUBMITTER	varchar	User ID of the Process submitter.
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.
USER_DATA_1	varchar	User metadata field 1.
USER_DATA_2	varchar	User metadata field 2.
USER_DATA_3	varchar	User metadata field 3.
USER_DATA_4	varchar	User metadata field 4.
VER	varchar	Transaction version.
XFER	varchar	The value of Y indicates a completed file transfer event. The value of N appears for all other event types.