Sterling Connect:Express virtual statistics table (V_CX_STATS_LOG)
The following table describes the data fields available from the Sterling Connect:Express Virtual Statistics (V_CX_STATS_LOG) table for IBM® Sterling Control Center Monitor reports:
Element | Type | Description |
---|---|---|
BEG_XFER_DATE |
varchar |
Beginning of transfer date time. The format is yyyy/mm/ddhh:mm:ss. |
CC_NAME |
varchar |
Empty. |
CX_EVENT_TYPE |
varchar |
Event type. Possible values:
|
CX_RET_CODE |
varchar |
Return code. |
DATE_TIME |
varchar |
Date and time that the event was generated in Coordinated Universal Time. The format is yyyy/mm/dd hh:mm:ss.msmsms. |
DEST_FILE |
varchar |
Destination file name in a copy operation. |
END_XFER_DATE |
varchar |
End of transfer date/time. The format is yyyy/mm/ddhh:mm:ss. |
EVENT_ID |
bigint |
ID number that is assigned by the system to each event. |
EVENT_TYPE |
bigint |
Code indicating the type of event. |
FILE_BYTES |
bigint |
File bytes transferred. |
FILE_LABEL |
varchar |
File label (PeSIT pi37). |
FILE_NAME |
varchar |
Name of file transferred. |
FILE_RECEIVER |
varchar |
Receiver of the file. |
FILE_SENDER |
varchar |
Sender of the file. |
FILE_SIZE |
bigint |
Size of file transferred. |
FROM_NODE |
varchar |
Server that sent the file. P=Pnode was sending server. S=Snode was sending server. |
LINK_TYPE |
varchar |
Type of link. The values:
|
LOCAL_FILE_NAME |
varchar |
Local file name. |
LOCAL_NODE_NAME |
varchar |
Local node name. |
MSG_ID |
varchar |
Server message ID issued with the event. |
NET_RET_CODE |
varchar |
Network return code. |
NETWORK_BYTES |
bigint |
Network bytes transferred. |
NODE_ID |
varchar |
Server name alias. |
NODE_NAME |
varchar |
Server name. |
NODE_TYPE |
varchar |
Code indicating the type of server. The server types:
|
OPERATING_SYSTEM |
varchar |
Operating system. |
ORIG_NODE |
varchar |
The server that initiated the Process. |
OTHER_NODE_NAME |
varchar |
Other node name. |
PROC_ID |
varchar |
Process/Request number. |
PROC_NAME |
varchar |
Sterling Connect:Express Process name. |
PROC_ORIGINATOR |
varchar |
Process Originator. The values:
|
PROT_RET_CODE |
varchar |
Protocol return code. |
RECORD_DATE |
varchar |
Record date. The format is yyyy/mm/dd hh:mm:ss.msmsms. |
RECORDS |
bigint |
Number of records transferred. |
REMOTE_NODE |
varchar |
Name of the remote server that is involved in the file transfer. |
REQUEST_NUMBER |
varchar |
Request number. |
RET_CODE |
varchar |
The system return code that is derived from the CX_RET_CODE, PROT_RET_CODE, and SYS_RET_CODE. If any of these elements are set, RET_CODE is set. |
SEQ_NUM |
bigint |
A number that is used to uniquely identify events that are generated at the same time. |
SHORT_MSG |
varchar |
Message text that is associated with the Message ID. |
SOURCE_FILE |
varchar |
Source file name in a copy. |
SUBMITTER |
varchar |
User ID of the process submitter. |
SYS_RET_CODE |
varchar |
System return code. |
TRANSFER_DIR |
varchar |
Transfer direction. Values:
|
TYPE_REQUEST |
varchar |
Request type. Values:
|
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. |
USER_DATA_RCVD |
varchar |
User data received (PeSIT pi99), associated to file. |
USER_DATA_SENT |
varchar |
User data sent (PeSIT pi99), associated to file. |
UTCOFFSET |
bigint |
Coordinated Universal Time offset when event transpired. |
XFER | varchar |
The value of Y indicates a completed file transfer event. The value of N appears for all other event types. |
XFER_DEST |
varchar |
Transfer destination. |
XFER_ID |
varchar |
Transfer identifier. |
XFER_ORIGIN |
varchar |
Transfer origin. |
XFER_PROTOCOL |
varchar |
File transfer protocol. Values:
|