Exporting Performance HDB data to DB2

After you have loaded data into an HDB it is then eligible for export to DB2®.

Summary HDB data is the most commonly used for performance reporting. It is already summarized by time.

List HDB data is typically used to drill down to isolate performance problems or for ad-hoc reporting. Take care when exporting List HDBs into DB2. The volume of data can be high, resulting in a table that is too large to manage.

Statistics HDB data is used for both short-term problem analysis and long-term trend analysis. Like List HDBs, take care when exporting Statistics HDBs into DB2. The volume of data can be high, resulting in a table that is too large to manage.

Select option 5 Export from the HDB menu to export HDB data into DB2.
Figure 1. Exporting Performance 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 CICSP1H  SUMMARY  Summary HDB for CICSP1           2004/12/07 15:25 JCH      
********************************* End of list *********************************
                                                                               
 F1=Help    F3=Exit    F7=Backward    F8=Forward    F10=Actions    F12=Cancel  
Select the required HDB to display its list of container data sets.
Figure 2. Export HDB
  File  Options  Help                                                          
------------------------------------------------------------------------------ 
                       Export SUMMARY HDB - CICSP1H            Row 1 to 1 of 1 
Command ===> ________________________________________________ Scroll ===> CSR_ 
                                                                               
Export HDB data set.                                                           
                                                                               
Name . . : CICSP1H                                                             
                                                                               
   Data Set Name                                       Start         Volume    
S  JCH.CICSP1H.D03219.T092846.HDB               2004/12/07 09:00:00  USER01    
********************************* End of list *********************************
                                                                               
 F1=Help      F3=Exit      F7=Backward  F8=Forward  F10=Actions  F12=Cancel    
CICS PA can only export one container data set at a time. Select the data set that contains the data in the required time range to be exported into DB2.
Figure 3. Export HDB Data Set
  File  Options  Help                                                      
-----------------------------------------------------------------------
                             Export HDB Data Set                           
Command ===> __________________________________________________________
                                                                           
HDB Name  . . . : CICSP1H                                                  
Data Set Name . : JCH.CICSP1H.D03219.T092846.HDB                           
                                                                           
Select option                                                              
1  1. Create DDL to define table        2. Load data into table            
                                                                           
Create Options                          Load Options                       
_  Create Database                      1  1. Resume                       
_  Create Storage Group                    2. Replace                      
                                                                           
DB2 Settings:                                                              
 DB2 Subsystem ID . . . DB2P                                               
 DSNTIAD Plan Name  . . DSNTIA91                                           
 DB2 Load Library . . . 'DB2.V910.SDSNLOAD'___________________________     
 DB2 Exit Library . . . 'DB2.V910.SDSNEXIT'___________________________     
 DB2 RUNLIB Library . . 'DB2.V910.RUNLIB.LOAD'________________________     
 Database . . . . . . . CICSPA__  Storage Group  . . SYSDEFLT              
 VCAT Catalog name  . . USER____  Volume . . . . . . DA0001                
 Allocation: Primary    20______  Secondary  . . . . 20____                
                                                                           
Include Clock Field Components          Summary Options                    
1  1. Time and Count                    /  Include Sums of Squares         
   2. Time only                                                           
   3. Count only                                                           
                                                                           
 F1=Help      F3=Exit      F7=Backward  F8=Forward  F10=Actions  F12=Cancel
Exporting HDB data into DB2 is a two step process, controlled by the Select Option. First step is to create the DDL to define the DB2 table. Second step is to load the data into the DB2 table. You can then use your favorite DB2 query tool to analyze the data.
  1. Creating DDL to define a DB2 table
  2. Loading data into the DB2 table
  3. Analyzing HDB DB2 Export data