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.

  1. Select option 2 Load data into table.
    Figure 1. Export Step 1. Create DB2 table
                   HDB Export Option Menu
     
     Select an option then press Enter.
     2  1. Create DDL to define table
        2. Load data into table
        3. Upgrade table to current version
  2. In the Export HDB Data Set panel, press Enter.
    Figure 2. Export Step 2. Load Data
       File  Options  Help 
     ──────────────────────────────────────────────────────────────────────────────
                            Export HDB Data Set - Load Data 
     Command ===>                                                                  
    
     Specify Load options then press Enter.
    
     HDB Name  . . . : CICSP1H 
     Data Set Name . : USR.CICSP1H.D03229.T092846.HDB              
    
     Load Options
     1  1. Resume                           
        2. Replace                          
    
     Include Clock Field Components          Summary Options
     1  1. Time and Count                    /  Include Sums of Squares
        2. Time only                        
        3. Count only                       
     
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.

Include Clock Field Components
CMF performance class clock fields accumulate data for both their count and time components in the HDB. Leave this set to Time and Count for maximum versatility.
Include Sums of Squares
Specify Include Sums of Squares to load sum-of-square values into the DB2 Table. CICS PA always loads the total. This allows you to calculate averages. Sums of squares are required to calculate standard deviation and peak percentiles. Totals (and not sums of squares) are sufficient for most analysis requirements.

This option must not be selected for an HDB that is intended to be used in the CICS PA plug-in.

Review the JCL then submit to load the DB2 table:

Figure 3. 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 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=USR.CICSP1H.D03229.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.