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        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.
  1. Create the DDL to define the DB2 table. See Creating DDL to define a DB2 table.
  2. Load the data. Loading data into the DB2 table.
You can then use your favorite DB2 query tool to analyze the data. Analyzing HDB DB2 Export data

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/hdbexportds.htm