Loading data into the DB2 table
CICS PA uses the DB2® Load Utility to load data into the DB2 table.
CICS PA builds the JCL that contains the DB2 Load Utility statement required to load the HDB data set into the DB2 table that was defined in the previous step.
The options are:
- Load Options
- Select Resume if you want the DB2 Load
Utility to resume loading data into the table. Typically, this is
appropriate for Summary HDBs.
Select Replace if you want the DB2 Load Utility to replace data already loaded in the table. Typically, this is appropriate for List HDBs.
Review the JCL then submit to load the DB2 table:
Figure 1. Edit JCL for HDB Export:
Load DB2 table
EDIT JCH.SPFTEMP1.CNTL Columns 00001 00072
Command ===> ________________________________________________ Scroll ===> CSR_
****** ***************************** Top of Data ******************************
000001 //CICSPA JOB ,NOTIFY=&SYSUID
000002 //* CICS PA V5R3 HDB - LOAD DATA INTO DB2 TABLE
000003 //DSNUPROC EXEC PGM=DSNUTILB,REGION=0M,
000004 // PARM='DB2P'
000005 //STEPLIB DD DISP=SHR,DSN=DB2.V910.SDSNLOAD
000006 // DD DISP=SHR,DSN=DB2.V910.SDSNEXIT
000007 //SYSPRINT DD SYSOUT=*
000008 //UTPRINT DD SYSOUT=*
000009 //SYSUDUMP DD SYSOUT=*
000010 //SYSREC DD DSN=JCH.CICSP1H.D03219.T092846.HDB,
000011 // DISP=SHR
000012 //SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
000013 //SORTOUT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
000014 //SYSIN DD *
000015 LOAD DATA RESUME YES
000016 INTO TABLE CICSPA.CICSP1H (
000017 START_DATE POSITION(1) DATE EXTERNAL(10),
000018 START_TIME POSITION(12) TIME EXTERNAL(8),
000019 MVSID POSITION(20) CHAR(4),
000020 APPLID POSITION(24) CHAR(8),
000021 TRAN POSITION(32) CHAR(4),
000022 TASKCNT POSITION(36) FLOAT,
000023 RESPONSE_TIME POSITION(44) FLOAT,
000024 RESPONSE_TIME_SSQ POSITION(52) FLOAT,
000025 DISPATCH_COUNT POSITION(60) FLOAT,
000026 DISPATCH_COUNT_SSQ POSITION(68) FLOAT,
000027 DISPATCH_TIME POSITION(76) FLOAT,
000028 DISPATCH_TIME_SSQ POSITION(84) FLOAT,
000029 CPU_COUNT POSITION(92) FLOAT,
000030 CPU_COUNT_SSQ POSITION(100) FLOAT,
000031 CPU_TIME POSITION(108) FLOAT,
000032 CPU_TIME_SSQ POSITION(116) FLOAT,
000033 SUSPEND_COUNT POSITION(124) FLOAT,
000034 SUSPEND_COUNT_SSQ POSITION(132) FLOAT,
000035 SUSPEND_TIME POSITION(140) FLOAT,
000036 SUSPEND_TIME_SSQ POSITION(148) FLOAT,
000037 DISPWAIT_COUNT POSITION(156) FLOAT,
000038 DISPWAIT_COUNT_SSQ POSITION(164) FLOAT,
000039 DISPWAIT_TIME POSITION(172) FLOAT,
000040 DISPWAIT_TIME_SSQ POSITION(180) FLOAT,
000041 FCWAIT_COUNT POSITION(188) FLOAT,
000042 FCWAIT_COUNT_SSQ POSITION(196) FLOAT,
000043 FCWAIT_TIME POSITION(204) FLOAT,
000044 FCWAIT_TIME_SSQ POSITION(212) FLOAT,
000045 IRWAIT_COUNT POSITION(220) FLOAT,
000046 IRWAIT_COUNT_SSQ POSITION(228) FLOAT,
000047 IRWAIT_TIME POSITION(236) FLOAT,
000048 IRWAIT_TIME_SSQ POSITION(244) FLOAT,
000049 SC24UHWM_COUNT POSITION(252) FLOAT,
000050 SC24UHWM_COUNT_SSQ POSITION(260) FLOAT,
000051 SC31UHWM_COUNT POSITION(268) FLOAT,
000052 SC31UHWM_COUNT_SSQ POSITION(276) FLOAT,
000053 TSWAIT_COUNT POSITION(284) FLOAT,
000054 TSWAIT_COUNT_SSQ POSITION(292) FLOAT,
000055 TSWAIT_TIME POSITION(300) FLOAT,
000056 TSWAIT_TIME_SSQ POSITION(308) FLOAT
000057 )
****** **************************** Bottom of Data ****************************
Review the job output in SDSF to verify that the table was created successfully.