Export HDB Data Set
To export HDB data into DB2®, you must create the DDL to define the DB2DB2 table and then load the data into the DB2DB2 table.
After loading the data, 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.
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.
For a Statistics HDB, you are first prompted to select the statistics reports to export. For all types of HDB, the HDB Export Option Menu is then displayed so you can select an operation.
HDB Export Option Menu
Select an option then press Enter.
1. Create DDL to define table
2. Load data into table
3. Upgrade table to current version
When you select an Export Option, the panel changes to display the options that are relevant for that Export Option. The name of the HDB and the selected container data set are displayed regardless of the selected Export Option.