Define a Performance HDB for export to DB2

The manifest should be rebuilt whenever you add or change an HDB in a way that affects its eligibility for inclusion in the manifest. For example, if an HDB is currently included in the manifest and you change its qualifier or clear the Explorer option, it is no longer eligible for inclusion in the manifest.

See Build the manifest.

  1. On the Historical Database menu, select option 2 Define.

    The New HDB Definition pop-up menu appears.

  2. Select the HDB type Performance and then press Enter.
    The New HDB Definition window appears:
      File  Systems  Options  Help
    ────────────────────────────────────────────────────────────────────────────── 
                                New HDB Definition 
    Command ===> _________________________________________________________________
    
    Specify new HDB definition options then press EXIT to save. 
    
    Name . . . . . . EXPLOR4P  APPLID ________ + Image ________
    Qualifier  . . . GF9IJG    /  Explorer                                       
    Description . .  Explorer HDB for CICS TS V4    
    
    HDB Format:                          Selection Criteria: 
     Template . . . EXPLOR41 +            _ Performance 
    
    Data Retention Period: 
     Years . . 1__   Months . . ___  Weeks . . ___  Days . . ___ Hours . . ___ 
    
    Data Set Allocation Settings: 
     DSN Prefix . . . . . . USER              
     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 . . . . . CYLS          (TRKS, CYLS) 
      Primary quantity . .  10            (In above units) 
      Secondary quantity    5             (In above units) 
    
    
     F1=Help     F3=Exit       F4=Prompt      F7=Backward   F8=Forward    F10=Actions 
    F12=Cancel
  3. Type a name for the HDB.

    If you plan to export to DB2®: The DB2 table name for a Performance HDB intended for the CICS PA plug-in is fixed as qualifier.CPA_CMFPSUM. This is unlike a user Performance HDB, where the DB2 table name is the same as the HDB name. Note that the qualifier is also specified as the Schema in the plug-in DB2 connection settings.

    When you export a Performance HDB to DB2, the CICS® PA dialog generates JCL to perform the export. This JCL specifies the DB2 table name. Do not change the DB2 table name in the generated JCL as this would result in the CICS PA plug-in not finding the DB2 table.

  4. Specify a Qualifier in ISPF member name format. This value is used as an identifier to associate related HDB tables in the manifest. It is also incorporated into the DB2 table name: qualifier.CPA_CMFPSUM.

    Multiple performance HDBs with the same qualifier will be exported to the same DB2 table. This allows you to consolidate data from multiple HDBs into a single DB2 table for analysis using the CICS PA plug-in.

  5. Select the Explorer option to make this HDB eligible for inclusion in the manifest. This also ensures that only internal templates are listed in the Template field.
  6. Press Prompt (F4) in the Template field to select an internal template that has been predefined for use with the CICS PA plug-in.
  7. Optionally, enter S in the Performance field to specify selection criteria for this HDB. (The internal template does not contain any selection criteria, so you must specify any required selection criteria here in the HDB.)
  8. Optionally, specify a data retention period indicating how long you want to keep data in this HDB. You can use the HDB Housekeeping program to delete container data sets whose data has expired.
  9. Specify the data set allocation settings. The only required fields are:
    • DSN prefix
    • Space units
    • Primary and secondary quantities
    CICS PA creates HDB data set names in the following pattern:
     dsn-prefix.hdb-name.Dyyddd.Thhmmss.HDB 
    where the date and time indicate when the HDB data set was allocated (CICS PA allocates the data set just before loading data).
  10. Press the Exit key (F3) to save the HDB definition.