This JCL contains the DB2® Load
Utility statements to load a System Logger extract data set into DB2.
Figure 1. Sample JCL CPALGLOD - Load System Logger extract into DB2//CPALGLOD JOB ,NOTIFY=&SYSUID
//DSNUPROC EXEC PGM=DSNUTILB,REGION=0M,
// PARM='<SSID>'
//STEPLIB DD DISP=SHR,DSN=<>
// DD DISP=SHR,DSN=<dsn.sdsnload>
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSREC DD DISP=SHR,DSN=<cicspa.logger>
//SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SORTOUT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSIN DD *
LOAD DATA
RESUME YES
INTO TABLE <CPALOGR>.LOGLIST (
RECTYPE POSITION(1) CHAR(8),
INTERVAL_DATE POSITION(10) DATE EXTERNAL(10),
INTERVAL_TIME POSITION(21) TIME EXTERNAL(8),
LOGSTREAM_NAME POSITION(30) CHAR(26),
STRUCT_NAME POSITION(57) CHAR(16),
SYSID POSITION(74) CHAR(4),
MVS_LEVEL POSITION(79) CHAR(8),
GROUP POSITION(88) CHAR(8),
STAGING_FLAG POSITION(97) CHAR(10),
IXGWRITE_COUNT POSITION(108) FLOAT,
IXGW_BLOCKLEN_MIN POSITION(117) FLOAT,
IXGW_BLOCKLEN_MAX POSITION(126) FLOAT,
IXG2_BYTES_REQUEST POSITION(135) FLOAT,
IXG2_BYTES_WRITTEN POSITION(144) FLOAT,
DASD_WRITES POSITION(153) FLOAT,
DASD_WRITE_WAITS POSITION(162) FLOAT,
DASD_SHIFTS POSITION(171) FLOAT,
STRUCT_REBUILD_INI POSITION(180) FLOAT,
STRUCT_REBUILD_COM POSITION(189) FLOAT,
FTRUCT_FULL POSITION(198) FLOAT,
STAGING_THRESHOLD POSITION(207) FLOAT,
STAGING_FULL POSITION(216) FLOAT,
OFFLOADS POSITION(225) FLOAT,
ENTRY_FULL POSITION(234) FLOAT,
DEMAND_OFFLOADS POSITION(243) FLOAT,
STAGING_A_BUF_FULL POSITION(252) FLOAT,
WRITTEN_BYTES POSITION(261) FLOAT,
INSTEAD_BYTES POSITION(270) FLOAT,
AFTER_BYTES POSITION(279) FLOAT,
INSTEAD_COUNT POSITION(288) FLOAT,
AFTER_COUNT POSITION(297) FLOAT,
TYPE_1_COMPLETIONS POSITION(306) FLOAT,
TYPE_2_COMPLETIONS POSITION(315) FLOAT,
TYPE_3_COMPLETIONS POSITION(324) FLOAT
)