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:

  • ConnectionError

  • ConnectionShutdownStarted

  • ConnectionStarted
  • NodeCommand

  • NodeError

  • NodeLicense
  • NodeStarted

  • NodeStatus

  • NodeShutdown

  • ProcessEnded

  • ProcessStarted

  • ProcessStepEnd

  • ProcessStepProgress

  • ProcessStepStart

  • TimerEvent

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:

  • T=TCPIP
  • S=SNA

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:
  • 0=IBM Sterling Control Center Monitor
  • 1=Sterling Connect:Direct®
  • 2=Sterling Connect:Enterprise®
  • 3=Sterling B2B Integrator
  • 4=FTP Server
  • 5=Sterling Connect:Express
  • 7=MQ MFT

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:
  • I=Local node is the originator.
  • E=Remote node is the originator.

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:

  • T=Transmit
  • R=Receive. If the value is R, the local node is receiving.

TYPE_REQUEST

varchar

Request type. Values:
  • N=Normal request that is submitted from pnode to snode to send or receive a file.
  • H=Hold request that is prepared by the snode for future transmission.
  • I=Inquiry that is submitted by the pnode for reception of a file that made available by a corresponding hold request on the snode.
  • M=Message
  • E= End to end response

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:

  • A=PeSIT E "PROF=ANY"
  • E=PeSIT Type E
  • D=PeSIT Type D
  • F=FTP
  • O=Odette
  • A=Compatible with PeSIT