HDB tour outline

Every aspect of the CICS PA Historical Database is controlled via the ISPF dialog.

This section takes you through the process of defining and using an HDB for CMF performance class data.

Setup. Initially, your HDB environment requires a minimal one-time setup. HDB definitions are saved in the Repository, a VSAM KSDS. CICS PA automatically defines the repository for you when you first try to use it.

Then the required steps are:
  1. Template.

    Defining an HDB is a two-step process: first define a Template and then define an HDB based on that Template. The Template identifies which CMF performance fields are to be kept in the HDB.

  2. Definition.

    After the Template is defined, then define the HDB and its options, such as the characteristics of the HDB data sets and the retention period of the data.

  3. Load.
    Loading data into the HDB is performed by the standard CICS PA batch reporting utility. The command that requests the utility to load an HDB is:
    HDB(LOAD(...
    CICS PA reads the CMF performance class data and builds the HDB data sets. Because the HDB Load process is part of the normal batch reporting process, you can run CICS PA reports and load HDBs together with a single pass of the SMF data.
  4. Report.
    Reporting against an HDB is performed by the standard CICS PA batch reporting utility. The command that requests the utility to report against an HDB is:
    HDB(REPORT(...

    You can tailor HDB reporting by using a Report Form. This allows you to select which fields in the HDB are reported and how they are presented.

  5. Export.
    Export allows you to load HDB data into a DB2® table. CICS PA automates this process with two simple steps:
    1. First define the DB2 table to house the data. CICS PA generates JCL to do this for you by creating the necessary DDL to define the table.
    2. Then load the data into the table. CICS PA generates JCL to do this for you by creating the necessary DB2 Load Utility statements to load the data.
  6. Extract.

    The HDB Extract facility allows you to export data from your HDB data sets to an extract data set in CSV format, suitable for import into PC-based spreadsheet applications for further analysis.

  7. Maintain.

    HDB maintenance allows you to change your HDB definition and manage the HDB container data sets.

  8. Housekeeping.
    HDB housekeeping should be run periodically to clean up your HDB environment. Housekeeping performs these tasks:
    1. Start of changeDeletes HDB container data sets that have expired or have delete pending.End of change
    2. Start of changeDeletes expired DB2 table rows.End of change
    3. Removes definitions from the Repository that are no longer required.
    For more information, see Housekeeping.

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


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