Description of the Statistics Files

S_REQ_ID

Alpha 23

Name of the flow that started this flow.

S_USERID

Alpha 32

Flow author.

S_APPNAME

Alpha 64

Flow application directory.

S_REQ_NAME

Alpha 64

Flow name.

STAT_SBM_T

Alpha 20

Submit date and time for a flow.

STAT_STRT_T

Alpha 20

Start date and time of execution.

STAT_END_T

Alpha 20

End date and time of execution.

STAT_RTRV_T

Alpha 20

Date and time of retrieval for a flow.

STAT_FORMAT

Alpha 15

Number of format rejections.

REQ_RC

Alpha 16

Internal return code for the flow.

TSCOMID

Alpha 15

TSCOMID for killing a job.

SESID

Alpha 15

SESID from EDAPRINT.

ORIG_REQ

Alpha 32

Original flow where dependency started.

ORIG_USER

Alpha 32

Original user ID running dependent flow.

DEP_CNT

Integer

Dependency number.

ETL__ERRTXT

Alpha 80

Text explanation of error messages.

FILLER

Alpha 30

Reserved for internal use. There are two columns with this field name.

USER_FILE_L

Alpha 9

Reserved for internal use.

RUN_BY_SCHED

Alpha 1

Scheduled request.

CPU_TIME

Alpha 15

Total CPU time in milliseconds.

S_TARG_NAME

Alpha 64

Target name.

Note: This and the remaining columns apply on a per target basis.

STAT_TRANS

Alpha 15

Number of rows processed.

STAT_ACCEPTS

Alpha 15

Number of rows accepted.

STAT_NOMATCH

Alpha 15

Number of rows rejected.

STAT_DBMSERR

Alpha 15

Number of rows rejected by the database for a constraint violation, such as a Unique Index constraint, a Not Null constraint, or a user-specified constraint.

STAT_INVALID

Alpha 15

Number of rows rejected for failing validation tests.

STAT_DUPLS

Alpha 15

Number of rejected duplicate records.

STAT_INPUT

Alpha 15

Number of rows input.

STAT_CHNGD

Alpha 15

Number of rows updated.

STAT_DELTD

Alpha 15

Number of rows deleted.