Export HDB Data Set

CICS PA can export several container data sets at a time. Select the data sets that contain the data in the required time range to be exported into DB2®.

Figure 1. Export HDB Data Set
  File  Options  Help                                                      
-----------------------------------------------------------------------
                             Export HDB Data Set                           
Command ===> __________________________________________________________
                                                                           
HDB Name  . . . : CICSWEEK                                                 
Data Set Name . : CICSPA.HISTORY.CICSWEEK.D03219.T092846.HDB               
                                                                           
Select option                                                              
1  1. Create DDL to define table        Start of change3. Upgrade table to current versionEnd of change
   2. Load data into table
 
Create Options                          Load Options                       
_  Create Database                      1  1. Resume                       
_  Create Storage Group                    2. Replace                      
                                                                           
Include Clock Field Components          Summary Options                    
1  1. Time and Count                    /  Include Sums of Squares         
   2. Time only                                                           
   3. Count only                                                           
 
Start of changeUpgrade Settings:                                                 
 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 . . . . . ________    (TRKS, CYLS)                            
  Primary quantity  . . ________    (In above units)                        
  Secondary quantity    ________    (In above units)                        
 End of change
 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.
  1. Create the DDL to define the DB2 table.
  2. Load the data into the DB2 table.
You can then use the CICS® PA plug-in or your favorite DB2 query tool to analyze the data. See Analyzing HDB DB2 Export data.

Loading data from multiple CICS releases into DB2

Performance (CMF) and Statistics fields are often added or removed in a new release of CICS TS or CICS TG. If your site is running multiple releases of CICS, not all fields will be in all releases. Since DB2 table definitions are release specific, you must define and load the data into release-specific tables.

Start of changeYou can also use option 3 on the Export HDB Data Set dialog to upgrade existing DB2 tables. Use this to allow for changes to field definitions in a new release of CICS TS or CICS TG or modifications to your HDB Template.End of change

Start of changeSee Upgrade DB2 tables.End of change