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
3. Upgrade table to current version
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
Upgrade 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)
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.
- Create the DDL to define the DB2 table.
- Load the data into the DB2 table.
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.
You 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.
See Upgrade DB2 tables.