Export to DB2
Use the HDB Export facility to export data that
has been loaded into HDB container data sets so that it can be accessed
using the CICS® PA
plug-in.
This option can also be used to upgrade data in an
existing table using a new template or statistics definition (see Upgrade DB2 tables).
- On the Historical Database menu, select option 5 Export.
The list of HDBs appears.
- Select the HDB that you want to export. The Export HDB panel appears, showing the list of container data sets for the selected HDB:
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.D12339.T140224.HDB 2012/12/04 00:06:00 DB0037 ******************************* Bottom of data ********************************
- Enter S next to the container data sets whose data you
want to export.
An HDB can consist of several data sets. You can export from one or more container data sets.
The Export HDB Data Set panel appears:File Options Help ────────────────────────────────────────────────────────────────────────────── Export HDB Data Set Command ===>__________________________________________________________________ HDB Name . . . : EXPLOR5P Data Set Name . : USER.EXPLORE5.D12339.T140224.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)
- 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 9.
Tip:You can change the default DB2 settings from the CICS PA Profile Options Menu or the Options action bar menu.
- If the DB2 table
has not already been created, select the option “Create DDL
to define table”. If the database or storage group that you
want to export to do not yet exist, then select the options to create
those, too.
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. The panel prompts you to press Enter again to proceed.
Press Enter again. An edit panel appears, containing JCL to create the required DB2 tables.
What DB2 tables will this define? For a performance HDB, CICS PA defines a DB2 table with the following name:qualifier.CPA_CMFPSUM
For a Performance List HDB that includes an alert definition, an additional DB2 table is created with the following name:qualifier.CPA_CMFPSUM_ALERT
For a statistics HDB, CICS PA defines one DB2 table for each STID, with the following name:qualifier.CPA_stid
For a Performance HDB, the generated JCL includes a step to create a DB2 view for use by the CICS PA plug-in.
- Enter sub to submit the JCL, and then press the Exit key (F3) to return to the CICS PA panel.
- Check the SYSPRINT file in the job output queue, to confirm that the tables were successfully defined.
- In the CICS PA panel, select the option "Load data
into table".
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.
- Enter sub on the command line to submit the job, and then press the Exit key (F3) to return to the CICS PA panel.