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.

Figure 1. New HDB Definition Menu
            New HDB Definition Menu     
                                        
Select an HDB type then press Enter.    
_  1. Performance - CMF List or Summary 
   2. Statistics  - CICS Statistics     
                                        
In the following example, we have given the HDB a name of CICSP1S and a description of Statistics HDB for CICSP1.
Figure 2. New HDB Definition
  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
The other options are:
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.CPA_stid
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.
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         
Start of change            ___  Monitoring                               No       No         End of change
          -  ___  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.
Specify each retention period as a whole number of years, months, weeks, days, or hours. Only one choice is allowed.

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.