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 V5R1 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.


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//guided-tours/loaddb2tab.htm