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.
- On the Historical Database menu, select option 2 Define.
The New HDB Definition pop-up menu appears.
- 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
- Type a name for the HDB.
- 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.
- Select the Explorer option to make this HDB eligible for inclusion in the manifest.
- 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.
- 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.
- Select the types of statistics you are interested in:
- EOD
- End-of-day
- REQ
- Requested
- USS
- Unsolicited
- INT
- Interval
- RRT
- Requested reset
- 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
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
- Press the Exit key (F3) to save the HDB definition.
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.