Load the HDB
- 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.
- 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
- Select the CICS® systems whose data you want to load.
- 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.
- 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).
- 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.
- 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.