Sterling Connect:Direct statistics table (V_CD_STATS_LOG)

The following table describes the data fields available from the Sterling Connect:Direct® Virtual Statistics (V_CD_STATS_LOG) table for IBM® Sterling Control Center Monitor reports:

Element	Type	Description
ALIAS_MEMBER_NAME	varchar	PDS alias member name.
BYTES_READ	bigint	Number of bytes read from the source file.
BYTES_RECEIVED	bigint	Number of bytes received by the destination file.
BYTES_SENT	bigint	Number of bytes sent to the destination file.
BYTES_WRITTEN	bigint	Number of bytes written to the destination file.
CB_ENC_ALG	varchar	Specifies the name of the encryption algorithm.
CC_NAME	varchar	Not completed.
CERT_ISSUER	text	Issuer value from certificate used.
CERT_SUBJECT	text	Subject name value from certificate used.
CHECK_POINT	varchar	Indicates whether Checkpoint is activated for this Process. The following are possible values: Y=Checkpoint is activated N=Checkpoint is not activated
CIPHER_SUITE	text	Name of cipher suite used.
CLASS	varchar	Determines the server-to-server session on which a Process can be executed.
COND_CODE	varchar	Return code that is associated with step termination. The following are typical codes: 0=Successful execution. 4=A warning level error was encountered. The statement probably finished normally, but verify the execution results. 8=An error occurred during execution. 16=A unrecoverable error occurred during execution. Note: This column is not populated in this table since it is duplicated in the Events table.
DATE_TIME	varchar	Date and time that the event was generated in UTC. The format is `yyyy/mm/dd hh:mm:ss.msmsms`.
DEBUG	varchar	For Sterling Connect:Direct for z/OS®, the DEBUG setting within the Process.
DEST_DISP_1	varchar	What to do with the destination file after a copy is complete. The following are possible values: NEW=Creates a file on the destination node. RPL=Creates a file on the destination node or, if the file exists, replaces the named file on the destination node. MOD=Appends data to the end of an existing file for which you have exclusive rights.
DEST_DISP_2	varchar	Disposition of the destination file after a normal Process step termination. The following are possible values: C=catalog K=Keep
DEST_DISP_3	varchar	Disposition of the destination file after an abnormal Process step termination. The following are possible values: C=Catalog D=Delete K=Keep
DEST_FILE	varchar	Destination file name. Note: This column is not populated in this table since it is duplicated in the Events table.
FASP_BANDWIDTH	bigint	Indicates how much bandwidth each FASP-enabled IBM Sterling Connect:Direct transfer can use.
FASP	varchar	Indicates whether FASP is enabled for IBM Sterling Connect:Direct transfers. Yes = FASP is enabled for IBM Sterling Connect:Direct transfers. No = FASP is not enabled for IBM Sterling Connect:Direct transfers.
FASP_POLICY	varchar	The FASP policy being used for an IBM Sterling Connect:Direct transfer. Possible values include: Fixed - FASP attempts to transfer at the specified target rate, regardless of the actual network capacity. This policy transfers at a constant rate and finishes in a guaranteed amount of time. High - FASP monitors the network and adjusts the transfer rate to fully utilize the available bandwidth up to the maximum rate. When congestion occurs, a FASP session with high policy transfers at a rate twice as fast as a session with fair policy. Fair - FASP monitors the network and adjusts the transfer rate to fully utilize the available bandwidth up to the maximum rate. When congestion occurs, FASP shares bandwidth with other traffic fairly by transferring at an even rate. Low - Similar to fair mode, the low policy uses the available bandwidth with up to the maximum rate, but is much less aggressive when sharing bandwidth with other network traffic. When congestion builds up, the transfer rate is decreased to the minimum rate, until other traffic retreats.
EVENT_ID	bigint	ID number that is assigned by the system to each event.
EXEC_PRIORITY	varchar	Priority under which the operating system thread that executes Sterling Connect:Direct runs. Applies to Microsoft Windows only.
EXT_COMPRESSION	varchar	Extended compression option. The following are possible values: Y=Extended compression is activated. N=Extended compression is not activated.
FEED_BACK	varchar	Feedback code for the module. The value depends on the module that creates it. Your IBM Support representative might ask for this value.
FROM_NODE	varchar	Node that sent the file. The following are possible values: S=SNODE P=PNODE Note: This column is not populated in this table since it is duplicated in the Events table.
FUNCTION_INFO	varchar	Specifies the function that is performed.
HOLD	varchar	Hold status of a Process. The following are the Hold statuses: No=The Process is not placed in the Hold queue. It is run as soon as resources are available. Yes=The Process is held in the Hold queue in Held Initially (HI) status until it is explicitly released. Call=The Process is held until the SNODE, as specified in the Process SNODE parameter, connects to the PNODE. The Process is then released for execution. The Process is also released when another Process on the PNODE connects to the SNODE.
LINK_FAIL	varchar	Indicated whether a link failure occurred during transmission. Link fail occurred. Link fail did not occur.
LOCAL_COND_CODE	varchar	Condition (return) code that is produced by the local server. See COND_CODE description for typical return codes.
LOCAL_MSG_ID	varchar	Specifies the message ID produced by the local server.
LOCAL_NODE	varchar	Server that processed the file. The following are possible values: S=SNODE P=PNODE
LOG_DATE_TIME	varchar	Date and time that the statistics record is written to the log file. Format `yyyy/mm/dd hh:mm:ss.msmsms`.
MEMBER_NAME	varchar	Name of the member copied.
MERGE_EA	varchar	Specifies the merged data encryption algorithm resulting from the merger of the PNODE and SNODE encryption algorithms.
MERGE_SIGN	varchar	Specifies the merged results from the digital signature settings for the PNODE and SNODE. If digital signature is enabled for either the PNODE or the SNODE, then digital signatures are used for the session. If digital signatures are not enabled for both the PNODE and SNODE, digital signatures are not used.
MSG_ID	varchar	Server or IBM Sterling Control Center Monitor message ID issued with the event. Note: This column is not populated in this table since it is duplicated in the Events table.
MSG_SHORT_TXT	varchar	Message short text. Note: This column is not populated in this table since it is duplicated in the Events table.
NODE_ID	varchar	Server alias. Note: This column is not populated in this table since it is duplicated in the Events table.
NODE_NAME	varchar	Name of the Sterling Connect:Direct server.
NODE_TYPE	varchar	Code indicating the type of server. Note: This column is not populated in this table since it is duplicated in the Events table.
OTHER_COND_CODE	varchar	Condition (return) code that is produced by the other (remote) server. See COND_CODE description for typical return codes.
OTHER_MSG_ID	varchar	Specifies the message ID produced by the other (remote) server.
PART_KEY	date	The date the statistics record is written to the log file. The format is `yyyy-mm-dd`.
PNODE	varchar	Primary node name. Note: This column is not populated in this table since it is duplicated in the Events table.
PNODE_ACCT_INFO	varchar	PNODE accounting information.
PNODE_ENC_ALG_LIST	varchar	Data encryption algorithm that is used on the PNODE.
PNODE_ENC_DATA	varchar	PNODE encryption data.
PNODE_PLEX_CLASS	varchar	PLEXCLASS of the PNODE.
PNODE_SIGN	varchar	Specifies whether signatures are enabled for the PNODE.
PREV_SIGN_VERIFIED	varchar	Specifies whether the previous encryption key is used for verifying the digital signature.
PRIORITY	varchar	Specifies the priority that is assigned to the Process. The lower the number the higher the priority.
PROC_NAME	varchar	Sterling Connect:Direct Process name. Note: This column is not populated in this table since it is duplicated in the Events table.
PROC_NUMBER	varchar	Sterling Connect:Direct Process number. Note: This column is not populated in this table since it is duplicated in the Events table.
QUEUE	varchar	Specifies the queue that contains the Process. The following are the queues available: Execution=Processes currently running. Hold=Processes that are either held by the user or operator or held because of execution errors. Timer=Processes that are scheduled to be run later, or Processes in time retry because of session errors. Wait=Processes that are eligible for execution and are awaiting selection.
RECORD_CATEGORY	varchar	Specifies whether the record is related to an event or to a Process. The following are the possible values: CAEV=The record is related to a Sterling Connect:Direct event, such as a Sterling Connect:Direct shutdown. CAPR=The record is related to a Sterling Connect:Direct Process.
RECORD_ID	varchar	Type of statistics record generated. See the Event Type Descriptions Help topic for a list of record IDs.
RECORDS_READ	bigint	Specifies the number of records that are read from the source file.
RECORDS_WRITTEN	bigint	Specifies the number of records that are written to the destination file.
RESTART	varchar	Indicates whether Restart is activated for the Process. The following are the possible values: Y=Restart is activated. N=Restart is not activated.
RETAIN	varchar	Indicates whether Sterling Connect:Direct retains a copy of a Process after it runs. The following are the Retain options: Initial=Specifies to retain the Process in the Hold queue for execution every time that Sterling Connect:Direct initializes. No=Specifies not to retain the Process after it is run. Yes=Specifies to retain the Process in the Hold queue after it is run. You can release the Process for execution later or delete it.
RU_SIZE	varchar	Specifies the size of buffers that are received by the destination file.
RUS_RECEIVED	bigint	Specifies the number of buffers that are received by the destination file.
RUS_SENT	bigint	Specifies the number of buffers that are sent to the destination file.
SCH_DATE_TIME	varchar	Specifies the date and time that a Process is scheduled to run. Format is `yyyy/mm/dd hh:mm:ss.msmsms`.
SECURE_ENABLED	varchar	Indicates that Sterling Connect:Direct Secure Plus is activated for the Process.
SECURE_PROTOCOL	text	Name of protocol that is used for secure connection.
SEQ_NUM	bigint	System-assigned sequence number. Note: This column is not populated in this table since it is duplicated in the Events table.
SERVER_NAME	varchar	Sterling Connect:Direct/Plex server name.
SNODE	varchar	Secondary node name. Note: This column is not populated in this table since it is duplicated in the Events table.
SNODE_ACCT_INFO	varchar	Specifies SNODE accounting information.
SNODE_ENC_ALG_LIST	varchar	Data encryption algorithm that is used on the SNODE.
SNODE_ENC_DATA	varchar	SNODE encryption data.
SNODE_PLEX_CLASS	varchar	PLEXCLASS of the SNODE.
SNODE_SIGN	varchar	Specifies whether digital signatures are enabled for the SNODE.
SOURCE_MEMBER_NAME	varchar	Source file member name.
SRC_DISP_1	varchar	Specifies access to the source file during a copy operation. The following are the source disposition values: SHR=The file can be opened by another Process for read-only access while it is being copied. OLD=The file cannot be opened by another Process during the transfer.
SRC_DISP_2	varchar	Disposition of the source file after a successful Process step termination.
SRC_DISP_3	varchar	Disposition of the source file after an abnormal Process step termination.
SRC_FILE	varchar	Source file name. Note: This column is not populated in this table since it is duplicated in the Events table.
START_TIME	varchar	Process start time.
STATUS	varchar	Specifies the Process status. The following are the possible statuses: Execution (EX)=The Process is running. Pending Execution (PE)=The Process is selected for execution and startup is in progress. Waiting Connection (WC)=The Process is ready to run, but all available connections to the SNODE are in use. Waiting Start Time (WS)=The Process is waiting in the Timer queue because it is submitted with a start time or date that has not expired. When the start time is reached, the Process is placed into the Wait queue for scheduling for execution. Held Suspension (HS)=The operator issued a delete Process request with Hold set to Yes. Timer Retry (RE)=A Process error occurred and the Process is moved to the Timer queue in RE status with short-term and long-term wait times beginning. Held for Call (HC)=The Process is submitted with the Hold parameter that is set to Call. A session started from either node moves the Process to the Wait queue in WC status. The Process is placed in the Execution queue when it is selected for execution. Held Due to Error (HE)=A session error or other abnormal condition occurred. Held Initially (HI)=The Process is submitted with the Hold option that is set to Yes. Held By Operator (HO)=A change Process request with Hold set to Yes was issued. Held By Retain (HR)=The Process was submitted with retain after execution set to Yes or Initial.
STD_COMPRESSION	varchar	Standard compression option. The following are the possible values: Y=Standard compression is activated N=Standard compression is not activated
STEP_NAME	varchar	Process step name. Note: This column is not populated in this table since it is duplicated in the Events table.
STOP_TIME	varchar	Process stop time.
SUB_DATE_TIME	varchar	Date and time that the Process was submitted. Format is `yyyy/mm/dd hh:mm:ss.msmsms`.
SUBMIT_NODE	varchar	Server where the submit operation was performed.
SUBMITER	varchar	User ID that submitted the Process. Note: This column is not populated in this table since it is duplicated in the Events table.
SUBMITTER_NODE	varchar	Server that submitted the Process.
SUR_SIGN_VERIFIED	varchar	Specifies whether the current encryption key was used for verifying the digital signature.
SYS_OPTS	varchar	Specifies the platform-specific system operations.
TARGET_MEMBER_NAME	varchar	Destination target member name.
TRANSLATION	varchar	Specifies whether the data was translated. The following are the possible values: Y=Data was translated. N=Data was not translated.
USER_DATA_1	varchar	Metadata field 1. Note: This column is not populated in this table since it is duplicated in the Events table.
USER_DATA_2	varchar	Metadata field 2. Note: This column is not populated in this table since it is duplicated in the Events table.
USER_DATA_3	varchar	Metadata field 3. Note: This column is not populated in this table since it is duplicated in the Events table.
USER_DATA_4	varchar	Metadata field 4. Note: This column is not populated in this table since it is duplicated in the Events table.