Guided Tour: Statistics HDB
Every aspect of the CICS PA Historical Database is controlled using the ISPF dialog.
This section takes you through the process of defining and using a Statistics HDB.
Setup. Initially, your HDB environment requires a minimal one-time setup. HDB definitions are saved in the repository, a VSAM KSDS. CICS PA automatically defines the repository for you when you first try to use it.
- Definition.
Unlike Performance HDBs, Statistics HDBs do not require a Template, so you can immediately define the HDB and its options, such as the characteristics of the HDB data sets and the retention period of the data.
- Load. Loading data into the HDB is performed by the CICS PA batch reporting utility. The command that requests the utility to load an HDB is:
CICS PA reads the CICS® statistics and server statistics data and builds the HDB data sets. Because the HDB Load process is part of the normal batch reporting process, you can run CICS PA reports and load HDBs together with a single pass of the SMF data.HDB(LOAD(...
- Report.
Statistics HDB reporting is done interactively using the CICS PA dialog and through the batch command utility.
Statistics Alert reporting alerts you when statistics field values meet specified conditions. The batch command that requests the utility to generate a Statistics Alert report against a Statistics HDB is:HDB(STATSALERT(...
Before requesting a Statistics Alert report, you must create a Statistics Alert Definition. For details, see Statistics alert reporting.
Statistics List reporting provides fully customizable batch reporting of CICS TS and CICS TG Statistics. For details, see Run Statistics HDB List report. The batch command to generate Statistics List reports against a Statistics HDB is as follows:HDB(STATISTICSLIST(...
Statistics Summary reporting provides customizable summary batch reports of CICS TS and CICS TG statistics records, including cross-domain reporting across multiple associated STIDs. For details see Run Statistics HDB Summary report. The batch command to generate Statistics Summary reports against a Statistics HDB is as follows:
HDB(STATISTICSSUMMARY(...
- Export. Export allows you to load HDB data into a DB2® table. CICS PA automates this process with two simple steps:
- First define the DB2 table to house the data. CICS PA generates JCL to do this for you by creating the necessary DDL to define the table.
- Then load the data into the table. CICS PA generates JCL to do this for you by creating the necessary DB2 Load Utility statements to load the data.
- Extract.
Extract allows you to extract HDB data into a CSV (comma separated variable) file, suitable for importing into a PC-based spreadsheet application.
The batch command to extract HDB data is as follows:
HDB(EXTRACT(...
- Maintain.
HDB maintenance allows you to change your HDB definition and manage the HDB container data sets.
- Delete HDB container data sets that have expired or have delete pending.
- Delete expired DB2 table rows.
- Remove definitions from the Repository that are no longer required.