Define a Statistics 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.

In addition, the manifest will only contain entries for statistics reports with a status of Collect=Yes or Alt and DB2 Load=Yes. If these indicators are not set, the report will not be included in the manifest and therefore will not accessible through the CICS PA plug-in. Therefore you should rebuild the manifest whenever any changes are made to the status of a statistics report in an eligible Statistics HDB.

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 Statistics 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 . . . . . . EXPLORST  APPLID ________ + Image ________
    Qualifier  . . . ________  _  Explorer                                       
    Description . .  Explorer Stats DB for CICS TS V4
    
    Statistics Reports:                          Alert Definition             
     _  Select to specify Statistics Reports      Alert  . . ________  +      
    
    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.
  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_statid, and is used as the Schema in the plug-in DB2 connection settings.

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

  5. Select the Explorer option to make this HDB eligible for inclusion in the manifest.
  6. Statistics HDBs, by default, do not collect any statistics. You must select Select to specify Statistics Reports and then press Enter to activate the types of statistics (reports) that you want to collect.
    • Use the A line action to activate collection for the corresponding report or category. This will result in status indicator Collect=Yes.
    • Use the AO line action to activate collection only of data that satisfies an Alert condition. This will result in status indicator Collect=Alt.
    • Use the AL line action to activate load to DB2. This will result in status indicator DB2 Load=Yes.

    Press Exit (F3) to save the Statistics Reports settings and return to the New HDB Definition panel.

  7. If you used line action AO against any report, or you used line action A (activate collection) against either of the Alert reports, you must specify an Alert Definition. Press Prompt (F4) in the Alert field to select from a list of Alert Definitions.
  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.