Load the HDB

  1. On the Historical Database menu, select option 3 Load. (You can also load the HDB from the Report Set panel by selecting HDB Load in the Extracts category.)

    The list of HDBs appears.

  2. Select the HDB that you want to load.
    The Load HDB pop-up window appears:
      File  Systems  Options  Help 
    ────────────────────────────────────────────────────────────────────────── 
                           Load SUMMARY HDB - EXPLOR5P 
    Command ===> _____________________________________________________________ 
    
    Specify HDB load options then press Enter to continue submit. 
    
    System Selection:                      ───── Report Interval ────── 
     APPLID . . ________  +                     YYYY/MM/DD HH:MM:SS.TH 
     Image . .  ________  +                From __________  __________
     Group . .  ________ +                 To   __________  __________
    
    DB2 Export Options:                    Table Load Options 
    _  Load DB2 Table                      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                      Enter "/" to select option 
                                           / Edit JCL before submit
  3. Select the CICS® systems whose data you want to load.
  4. Specify the time interval of the data that you want to load.

    If you omit the time interval, and there is more than one SMF data set for the systems that you selected, then CICS PA selects all SMF data sets defined for that system.

  5. If you want to load the HDB and export the data to the DB2 tables in a single job, select Load DB2 Table option and specify Table Load Options. Note that to do this the DB2 table must already be defined.

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

  6. Press Enter to submit the load job.

    If you selected the "Edit JCL before submit", then the JCL appears in an edit panel. To submit the job, enter sub on the command line, and then press the Exit key (F3) to return to the CICS PA panel.

  7. Check the results of the load job. In SDSF, list the data sets for the job, and then browse the data set named HDBLnnnn: this contains the "HDB LOAD Recap Report", which describes the success or failure of the load.

If you did not select Load DB2 Table option, only the HDB is loaded at this point. You will need to export the data in the HDB to DB2® tables.


Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//LoadTheHDB.htm