Define a Statistics HDB for export to DB2

Defining a Statistics HDB allows you to collect (load) and report historical CICS® statistics and server statistics data and CICS Transaction Gateway statistics data for later analysis using the CICS PA plug-in.

  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  . . ________  +      
                                                                                
     Interval Type  . . /  EOD  /  INT  /  USS  /  REQ  /  RRT    
    
    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.
  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_stid, and is used as the Schema (qualifier) in the plug-in DB2 connection settings.

    Multiple Statistics HDBs with the same qualifier will be exported to the same set of DB2 stid 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. Enter / next to 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. Select the types of statistics you are interested in:
    EOD
    End-of-day
    REQ
    Requested
    USS
    Unsolicited
    INT
    Interval
    RRT
    Requested reset
  9. 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.
  10. 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).
  11. Press the Exit key (F3) to save the HDB definition.
Note: Rebuild the manifest 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.

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 be 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.