Exporting Statistics HDB data to DB2

Select option 5 Export from the HDB menu to export HDB data into DB2®.

Unlike Performance HDBs, Statistics HDBs do not have a common record format. The records for each statistics report (or type, as identified by its CICS® domain and statistics ID) have a different record format. Therefore one DB2 table must be defined for each type of statistics record to be exported.

Figure 1. Exporting Statistics HDBs
  File  Options  Help                                                         
------------------------------------------------------------------------------
                                Export HDBs                    Row 1 to 1 of 1
Command ===> ________________________________________________ Scroll ===> CSR_
                                                                              
Select to export HDB to DB2.                                                   
                                                                               
   Name     Type              Description                Changed        ID     
S CICSP1S  STATS    Statistics HDB for CICSP1        2005/03/16 12:23 JCH      
********************************* End of list *********************************
                                                                               
  F1=Help      F3=Exit      F5=Rfind     F7=Backward  F8=Forward  F10=Actions 
 F12=Cancel                                                                   
In this example, we have selected our statistics HDB for exporting to DB2.
Select the required HDB to display its list of container data sets.
Figure 2. Export Statistics HDB
  File  Options  Help                                               
-------------------------------------------------------------------------------
                         Export STATS HDB - CICSP1S             Row 1 to 2 of 2
 Command ===> ________________________________________________ Scroll ===> PAGE
                                                                              
 Select to export HDB data sets to DB2.                                        
                                                                              
 HDB Name . . : CICSP1S   Type . . : STATS                                     
                                                                              
   Data Set Name                                ------ Start ------  Volume    
 S CICSPA.CICSP1.D05074.T102306.HDB             2005/03/15 07:00:00  USER05    
 S CICSPA.CICSP1.D05074.T152311.HDB             2005/03/15 14:00:00  USER05    
 S CICSPA.CICSP1.D05075.T042316.HDB             2005/03/16 02:00:00  USER05    
 ****************************** Bottom of data ******************************
The list of statistics reports is displayed.
Figure 3. Select Statistics reports for export to DB2
  File  Edit  Options  View  Help                                             
------------------------------------------------------------------------------
EXPORT                       Statistics Reports                   Line 1 of 25
Command ===> ________________________________________________ Scroll ===> CSR_
 
Select reports to export to DB2.
                                                                   DB2        
___          ** Reports **                                Collect  Load       
     -  ___  Regions                                      Yes      No         
             ___  Transaction Manager                     Yes      No         
          -  ___  CICS Dispatcher                         Yes      No         
                  ___  Dispatcher Overview                Yes      No         
                  ___  Dispatcher TCB Modes               Yes      No         
                  ___  Dispatcher TCB Pools               Yes      No         
                  ___  MVS TCB Overview                   Yes      No         
                  ___  MVS TCBs                           Yes      No         
          -  ___  CICS Storage                            Yes      No         
                  ___  Storage Overview                   Yes      No         
                  S__  DSAs                               Yes      No         
                  ___  Domain Subpools                    Yes      No         
                  ___  Task Subpools                      Yes      No         
          +  ___  CICS Dumps                              Yes      No         
             ___  Enqueue Pools                           Yes      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         
     +  ___  CICS Web Support                             No       No         
     +  ___  Java and Enterprise Java                     No       No         
     +  ___  Miscellaneous                                No       No         
     +  ___  CICS Server                                  No       No         
     +  ___  CICS Transaction Gateway                     No       No         
             ** End of Reports **                                             

Enter line action S to select the reports that you want to export to DB2.

Only the reports that you select are exported to DB2. The DB2 Load column is ignored: this column is only used when loading the HDB with the Load DB2 Table option selected.

In the following example, we have selected the DSAs report.