Step 2. Load the DB2 table
The second step loads the DB2® table.
Figure 1. Export Step 2. Load DB2 table
Select option 2 Load Data. File Options Help
──────────────────────────────────────────────────────────────────────────────
Export HDB Data Set - Load Data
Command ===>
Specify Load options then press Enter.
HDB Name . . . : DB2TST1
Data Set Name . : USERID.HISTORY.DB2T1.D16200.T095455.HDB
Load Option Statistics data VRMs to be loaded
1 1. Resume TS: 700 + + +
2. Replace TG: 910 + + +
Note: The TS and TG fields provide the
ability to export data from multiple CICS® TS and CICS TG releases, into a single DB2 table for each statistics ID. If you specify more than one Transaction Server or
Transaction Gateway VRM, CICS PA generates multiple Load
statements in the JCL, each using an IGNOREFIELDS YES operand if any fields were removed in the
later VRMs.
The generated JCL is displayed in an edit session for review and
submission.
Figure 2. Edit
JCL to load DB2 table
EDIT SYB.SPFTEMP3.CNTL Columns 00001 00072
Command ===> SUB_____________________________________________ Scroll ===> PAGE
****** ***************************** Top of Data ******************************
000001 //SYB#CPA JOB ,NOTIFY=&SYSUID
000002 //* CICSPA V5R4 HDB - LOAD DATA INTO DB2 TABLE
000003 //DSNUPROC EXEC PGM=DSNUTILB,REGION=0M,
000004 // PARM='DB2P'
000005 //STEPLIB DD DISP=SHR,DSN=DB2.PROD.SDSNLOAD
000006 // DD DISP=SHR,DSN=DB2.PROD.SDSNEXIT
000007 //SYSPRINT DD SYSOUT=*
000008 //UTPRINT DD SYSOUT=*
000009 //SYSUDUMP DD SYSOUT=*
000010 //SYSREC DD DSN=SKU.#180203.D05049.T182306.HDB,
000011 // DISP=SHR
000012 // DD DSN=SKU.#180203.D05049.T182311.HDB,
000013 // DISP=SHR
000014 // DD DSN=SKU.#180203.D05049.T182316.HDB,
000015 // DISP=SHR
000016 //SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
000017 //SORTOUT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
000018 //SYSIN DD *
000019 LOAD DATA RESUME YES
000020 INTO TABLE CICSPA.HST014B WHEN (70) = '014B' (
000021 START_DATE POSITION(1) DATE EXTERNAL(10),
000022 START_TIME POSITION(12) TIME EXTERNAL(8),
000023 APPLID POSITION(20) CHAR(8),
000024 MVSID POSITION(28) CHAR(4),
000025 DSA_NAME POSITION(77) CHAR(8),
000026 DSA_LOCATION POSITION(85) CHAR(8),
000027 ACCESS POSITION(93) CHAR(8),
000028 DSA_INDEX POSITION(101) CHAR,
000029 DSA_SIZE_CUR POSITION(102) INTEGER,
000030 DSA_SIZE_PEAK POSITION(106) INTEGER,
000031 CUSHION_SIZE POSITION(110) INTEGER,
000032 GETMAIN_REQUESTS POSITION(114) INTEGER,
. . .