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 . . . . . . EXPLOR5P  APPLID ________ + Image ________
    Qualifier  . . . GF9IJG    /  Explorer                                       
    Description . .  Explorer HDB for CICS TS V5    
    
    HDB Format:                          Selection Criteria: 
     Template . . . EXPLOR51 +            _ Performance 
    
    Data Retention Period: 
     HDB: Years  1__  Months  ___  Weeks  ___  Days  ___  Hours  ___              
     DB2: Years  ___  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 names for a Performance HDB intended for the CICS PA plug-in are fixed as qualifier.CPA_CMFPSUM and qualifier.CPA_CMFACSUM. 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, for example: 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. Alternatively, you can specify the selection criteria in the Template by editing the Template.
  8. Optionally, specify data retention periods indicating how long you want to keep the container data sets and DB2 rows associated with this HDB. You can use the HDB Housekeeping program to delete expired container data sets and DB2 rows. If the HDB container data sets are no longer required after their data has been exported to DB2, specify a retention period of 0 in any of the HDB periods to make the data sets expire immediately.
  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.

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/DefinePerfHDB.htm