Defining a Statistics HDB
Defining a Statistics HDB allows you to collect (load) and report historical CICS® statistics and server statistics data and CICS Transaction Gateway statistics data. The definition alone does not cause any action by CICS PA.
Select option 2 Define from the HDB menu to define a new HDB. Then when prompted, select option 2 to create a Statistics HDB.
New HDB Definition Menu
Select an HDB type then press Enter.
_ 1. Performance - CMF List or Summary
2. Statistics - CICS Statistics
File Systems Options Help
----------------------------------------------------------------------------
New HDB Definition
Command ===> _______________________________________________________________
Specify new HDB definition options then press EXIT to save.
Name . . . . . . CICSP1S APPLID CICSP1 + Image MVS1
Qualifier . . . ________ _ Explorer
Description . . Statistics HDB for CICSP1
Statistics Reports: Alert Definition
_ Select to specify Statistics Reports Alert . . ________ +
Interval Type . . / EOD / INT / USS / REQ / RRT
Data Retention Period:
HDB: Years 10_ Months ___ Weeks ___ Days ___ Hours ___
DB2: Years ___ Months ___ Weeks ___ Days ___ Hours ___
Data Set Allocation Settings:
DSN Prefix . . . . . .
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 10 (In above units)
F1=Help F3=Exit F4=Prompt F7=Backward F8=Forward F10=Actions F12=Cancel
- APPLID
- APPLID is optional and specifies the CICS system that the HDB applies to. You can
use Prompt (F4) to select from a list of CICS systems defined in your System Definitions.
Specify APPLID to ensure that only data for this CICS system is loaded into the HDB. At Load time, CICS PA will generate JCL that includes this APPLID in the command deck and DD statements for this system's SMF Files.
- Qualifier
- If Qualifier is specified, the value is used as the DB2® schema in place of the Database as specified
in DB2 Settings. It is also
incorporated into the DB2 table
name:
Qualifier is mandatory if Explorer is selected, and optional otherwise. If Qualifier and Explorer are both entered then details of this HDB will be included in the manifest for the CICS PA plug-in the next time it is rebuilt for this qualifier.qualifier.CPA_stid
- Explorer
- Select the Explorer option to make this HDB eligible for inclusion in the manifest for the CICS PA plug-in.
- Statistics Reports
- Enter / next to Select to specify Statistics Reports to
activate the types of statistics (reports) that you want to collect.
In the following example, we have activated collection for three CICS Dispatcher reports and all four CICS Storage reports.Figure 3. Activate statistics reports for HDB data collection
File Edit Options View Help ------------------------------------------------------------------------------ Statistics Reports Line 1 of 30 Command ===> ________________________________________________ Scroll ===> CSR_ DB2 ___ ** Report ** Collect Load + ___ CICS Performance Analyzer - CICS TS No No - ___ Regions Yes No ___ Transaction Manager No No
___ Monitoring No No
- ___ CICS Dispatcher Yes No A__ Dispatcher Overview Yes No A__ Dispatcher TCB Modes Yes No A__ Dispatcher TCB Pools Yes No ___ MVS TCB Overview No No ___ MVS TCBs No No - A__ CICS Storage Yes No ___ Storage Overview Yes No ___ DSAs Yes No ___ Domain Subpools Yes No ___ Task Subpools Yes No + ___ CICS Dumps No No ___ Enqueue Pools No No ___ BUNDLE Resources No No + ___ Connectivity No No + ___ Files and Databases No No + ___ Logging No No + ___ Queues No No + ___ Transactions No No + ___ Programs No No + ___ Event Processing No No + ___ CICS Web Support No No + ___ Java and Enterprise Java No No + ___ Miscellaneous No No + ___ CICS Server No No + ___ CICS Performance Analyzer - CICS TG No No + ___ CICS Transaction Gateway No No ** End of Reports **
When you load a statistics HDB, you can also choose to export the data to DB2. The DB2 Load column identifies the statistics reports that are exported.
Exit (F3) to save the collection and DB2 load settings.
- Alert
- 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.
- Interval Type
- Select the types of statistics you are interested in:
- EOD
- End-of-day
- REQ
- Requested
- USS
- Unsolicited
- INT
- Interval
- RRT
- Requested reset
- Data Retention Period
- These fields separately specify the length of time
that HDB data sets and associated DB2 table rows are kept before they
expire. Typically:
- Summary HDBs need to keep their container data sets for many years for long-term trend analysis.
- List HDBs used for ad hoc reporting might only need to keep their container data sets for a couple of hours or days.
If the HDB container data sets are no longer required after their data has been exported to DB2, you can specify a retention period of 0 in any of the HDB periods to make the HDB data sets expire immediately.
Container data sets and DB2 data are deleted by HDB Housekeeping after they have passed their expiry date. If you do not specify a retention period, the corresponding HDB data sets or DB2 data will never expire.
Use HDB Maintenance to check container data set status or to alter the HDB or DB2 retention period.
- Data Set Allocation Settings
- Data Set Allocation Settings specify the allocation attributes
of the data sets that contain data for this HDB. CICS PA dynamically
allocates container data sets at load time.
The format of the data set name is
DSN-prefix.HDB-name.Dyyddd.Thhmmss.HDB
where the DSN prefix is the data set name high level qualifier.
Specify allocation settings that satisfy your installation requirements. The size of container data sets is not critical. Typically you would specify a size that accommodates a single load request. For example, if you load data into the HDB daily, then 10 cylinders might be sufficient. However if CICS PA encounters an out-of-space condition (ABENDx37) during load, then it simply closes the data set and recommences loading in a new data set. You can decide to specify a larger size initially and adjust it later using HDB Maintenance.
Exit (F3) to save the HDB. You are now ready to use this HDB.