Export to DB2

Start of changeUse the HDB Export facility to export data that has been loaded into HDB container data sets so that it can be accessed using the CICS® PA plug-in.End of change

Start of change This option can also be used to upgrade data in an existing table using a new template or statistics definition (see Upgrade DB2 tables).End of change

  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 - EXPLORE5        Row 1 to 1 of 1 
    Command ===> _________________________________________________ Scroll ===> PAGE 
    
    Select to export HDB data sets to DB2.
    
    HDB Name . . : EXPLORE5     Type . . : SUMMARY 
    
       Data Set Name                                   ------ Start ------ Volume 
       USER.EXPLORE5.D12339.T140224.HDB                  2012/12/04 00:06: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  . . . : EXPLOR5P
    Data Set Name . : USER.EXPLORE5.D12339.T140224.HDB
    
    Select option                                                  
    1  1. Create DDL to define table        Start of change3. Upgrade table to current versionEnd of change
       2. Load data into table
    
    Create Options                           Load Options 
    _  Create Database                       1 1. Resume 
    _  Create Storage Group                    2. Replace 
     
    
    Include Clock Field Components          Summary Options           
    1  1. Time and Count                    _  Include Sums of Squares
       2. Time only                                                   
       3. Count only                                                  
    
    Start of changeUpgrade Settings:                                                 
     Management class . . . ________    (Blank for default management class)    
     Storage class  . . . . ________    (Blank for default storage class)       
      Volume serial . . . . ______      (Blank for system default volume)       
      Device type . . . . . ________    (Generic unit or device address)        
     Data class . . . . . . ________    (Blank for default data class)          
      Space Units . . . . . ________    (TRKS, CYLS)                            
      Primary quantity  . . ________    (In above units)                        
      Secondary quantity    ________    (In above units)                        
     End of change
  4. 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 9.

    Tip: Start of changeYou can change the default DB2 settings from the CICS PA Profile Options Menu or the Options action bar menu.End of change
  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 DB2 table with the following name:
    qualifier.CPA_CMFPSUM
    For a Performance List HDB that includes an alert definition, an additional DB2 table is created with the following name:
    qualifier.CPA_CMFPSUM_ALERT
    For a statistics HDB, CICS PA defines one DB2 table for each STID, with the following name:
    qualifier.CPA_stid

    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.