Export to DB2

  1. On the Historical Database menu, select option 5 Export.

    The list of HDBs appears.

  2. Select the HDB that you want to export.
    The Export HDB panel appears, showing the list of container data sets for the selected HDB:
      File  Options  Help 
    ────────────────────────────────────────────────────────────────────────────── 
                              Export SUMMARY HDB - EXPLORE4        Row 1 to 1 of 1 
    Command ===> _________________________________________________ Scroll ===> PAGE 
    
    Select to export HDB data sets to DB2.
    
    HDB Name . . : EXPLORE4     Type . . : SUMMARY 
    
       Data Set Name                                   ------ Start ------ Volume 
       USER.EXPLORE4.D05332.T180224.HDB                  2009/02/20 00:05:00 DB0037 
    ******************************* Bottom of data ********************************
  3. Enter S next to the container data sets whose data you want to export.

    An HDB can consist of several data sets. You can export from one or more container data sets.

    The Export HDB Data Set panel appears:
      File  Options  Help
    ──────────────────────────────────────────────────────────────────────────────
                                   Export HDB Data Set
    Command ===>__________________________________________________________________
    
    HDB Name  . . . : EXPLOR4P
    Data Set Name . : USER.EXPLORE4.D05332.T180224.HDB
    
    Select option                                                  
    1  1. Create DDL to define table        2. Load data into table
    
    Create Options                           Load Options 
    _  Create Database                       1 1. Resume 
    _  Create Storage Group                    2. Replace 
    
    DB2 Settings: 
     DB2 Subsystem ID . . . DH2C 
     DSNTIAD Plan Nam e . . DSNTIA91 
     DB2 Load Library . . . 'DB2.V910.SDSNLOAD'                         
     DB2 Exit Library . . . 'DB2.V910.SDSNEXIT'                          
     DB2 RUNLIB Library . . 'DSN910.RUNLIB.LOAD'                         
     Database . . . . . . . FGSI87FC  Storage Group  . . SYSDFLT 
     VCAT Catalog name  . . DB2CAT    Volume . . . . . .       
     Allocation: Primary    10        Secondary  . . . . 5     
    
    Include Clock Field Components          Summary Options           
    1  1. Time and Count                    _  Include Sums of Squares
       2. Time only                                                   
       3. Count only                                                  
  4. Contact your DB2® administrator for your local DB2 settings, and then type the values into the panel.

    Exporting an HDB to DB2 is a two-step process. First, you use this panel to create and submit JCL that defines the DB2 tables (and, optionally, the database and storage group) that will contain the exported data. Second, you use the panel to create and submit JCL that loads data into the tables.

    You only need to define the DB2 tables, database and storage group once. If these are already defined, go to step 1.

  5. If the DB2 table has not already been created, select the option “Create DDL to define table”. If the database or storage group that you want to export to do not yet exist, then select the options to create those, too.

    For a Performance HDB, ensure that Include Clock Field Components is set to 1 (Time and Count), and Summary Options is not selected (blank).

  6. Press Enter. The panel prompts you to press Enter again to proceed.

    Press Enter again. An edit panel appears, containing JCL to create the required DB2 tables.

    What DB2 tables will this define? For a performance HDB, CICS® PA defines a single DB2 table with the following name:
    qualifier.CPA_CMFPSUM
    For a statistics HDB, CICS PA defines one DB2 table for each stat ID, with the following name:
    qualifier.CPA_statid

    For a Performance HDB, the generated JCL includes a step to create a DB2 view for use by the CICS PA plug-in.

  7. Enter sub to submit the JCL, and then press the Exit key (F3) to return to the CICS PA panel.
  8. Check the SYSPRINT file in the job output queue, to confirm that the tables were successfully defined.
  9. In the CICS PA panel, select the option "Load data into table".

    For a Performance HDB, ensure that Include Clock Field Components is set to 1 (Time and Count), and Summary Options is not selected (blank).

    The JCL to perform the load appears in an edit panel.

  10. Enter sub on the command line to submit the job, and then press the Exit key (F3) to return to the CICS PA panel.