Define a Performance HDB for export to DB2
Defining a Performance HDB allows you to collect (load) and report historical performance data for later analysis using the CICS® PA plug-in.
- On the Historical Database menu, select option 2 Define.
The New HDB Definition pop-up menu appears.
- 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 Load Options: Selection Criteria: Template . . . . EXPLOR52 + _ Performance Alert . . . . . ________ + Severity . . . ________ + Summary Interval ________ (hh:mm:ss) Data Retention Period: HDB: Years 1__ Months ___ Weeks ___ Days ___ Hours ___ DB2: Years ___ Months 2__ 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
- 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 (qualifier) 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.
- 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.
- 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.
- Press Prompt (F4) in the Template field to select an internal template that has been predefined for use with the CICS PA plug-in. Summary templates are named EXPLORxx (where xx is the CICS TS version number) and APPLNMxx for Application Context data. List templates are named EXPLSTxx.
- 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.
- Optionally, for HDBs that are based on a List template,
you can specify an alert definition to be used during the load. The loading of a List HDB that is
defined with a Performance Alert definition results in the creation
of an additional set of containers to store Alert records.
The Severity field controls the type of transaction records and alerts loaded into the HDB in the same way as in the Performance List report. You can use this option to focus the loaded data on specific transaction types.
- CRITICAL
- Only transactions with critical alerts are loaded.
- WARNING
- Only transactions with critical alerts and warning alerts are loaded.
- INFO
- Only transactions with critical alerts, warning alerts, or informational alerts are loaded.
- ELIGIBLE
- Only transactions that are eligible for alert processing are loaded. Eligible transactions are those that have field values that match the Resource values in the Performance Alert Definition. All eligible transactions are loaded regardless of whether they generate an alert.
- ALL
- All transactions are loaded regardless of whether they are eligible or whether they generate an alert. Use this option to load a general List HDB for normal reporting while also generating any associated alert, thus avoiding the need to create two separate HDBs.
- Optionally, specify a Summary Interval to override the time interval defined in the template. This means that the internal templates that are predefined for use with the CICS PA plug-in can be used in multiple HDBs that each require a different interval.
- 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.
- 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 and any optional performance alert containers (HPA) in the following pattern:
where the date and time indicate when the HDB data set was allocated (CICS PA allocates the data set just before loading data).DSN-prefix.HDB-name.Dyyddd.Thhmmss.HDB DSN-prefix.HDB-name.Dyyddd.Thhmmss.HPA
- Press the Exit key (F3) to save the HDB definition.