The list of HDBs appears.
File Options Help ────────────────────────────────────────────────────────────────────────────── Export SUMMARY HDB - EXPLORE5 Row 1 to 1 of 1 Command ===> _________________________________________________ Scroll ===> PAGE Select to export HDB data sets to DB2. HDB Name . . : EXPLORE5 Type . . : SUMMARY Data Set Name ------ Start ------ Volume USER.EXPLORE5.D05332.T180224.HDB 2009/02/20 00:05:00 DB0037 ******************************* Bottom of data ********************************
An HDB can consist of several data sets. You can export from one or more container data sets.
File Options Help ────────────────────────────────────────────────────────────────────────────── Export HDB Data Set Command ===>__________________________________________________________________ HDB Name . . . : EXPLOR5P Data Set Name . : USER.EXPLORE5.D05332.T180224.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 . . . DH2C DSNTIAD Plan Nam e . . DSNTIA91 DB2 Load Library . . . 'DB2.V910.SDSNLOAD' DB2 Exit Library . . . 'DB2.V910.SDSNEXIT' DB2 RUNLIB Library . . 'DSN910.RUNLIB.LOAD' Database . . . . . . . FGSI87FC Storage Group . . SYSDFLT VCAT Catalog name . . DB2CAT Volume . . . . . . Allocation: Primary 10 Secondary . . . . 5 Include Clock Field Components Summary Options 1 1. Time and Count _ Include Sums of Squares 2. Time only 3. Count only
Exporting an HDB to DB2 is a two-step process. First, you use this panel to create and submit JCL that defines the DB2 tables (and, optionally, the database and storage group) that will contain the exported data. Second, you use the panel to create and submit JCL that loads data into the tables.
You only need to define the DB2 tables, database and storage group once. If these are already defined, go to step 1.
For a Performance HDB, ensure that Include Clock Field Components is set to 1 (Time and Count), and Summary Options is not selected (blank).
Press Enter again. An edit panel appears, containing JCL to create the required DB2 tables.
qualifier.CPA_CMFPSUM
qualifier.CPA_statid
For a Performance HDB, the generated JCL includes a step to create a DB2 view for use by the CICS PA plug-in.
For a Performance HDB, ensure that Include Clock Field Components is set to 1 (Time and Count), and Summary Options is not selected (blank).
The JCL to perform the load appears in an edit panel.