Step 2. Load the DB2 table

The second step loads the DB2® table.
Figure 1. Export Step 2. Load DB2 table
   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      +      +      +
 
Select option 2 Load Data.
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,                  
. . .