HDB Export to DB2 tables
After you have loaded data into an HDB it is then eligible for export to DB2®.
Summary HDB data is the most commonly used for performance reporting. It is already summarized by time.
List HDB data is typically used to drill down to isolate performance problems or for ad-hoc reporting. Take care when exporting List HDBs into DB2. The volume of data can be high, resulting in a table that is too large to manage. If an alert definition is specified, the associated performance alert data is stored in separate container data sets which need to be loaded, exported, and managed separately.
Stats HDB data is used to store CICS® statistics data for short-term or long-term analysis.
Select option 5 Export from the HDB menu to export HDB data into a DB2 table
or to upgrade the data in an existing table to use a
new template or statistics definition
.
or to upgrade the data in an existing table to use a
new template or statistics definition
.
Figure 1. HDB exporting
File Explorer Options Help
------------------------------------------------------------------------------
Export HDBs Row 1 to 5 of 5
Command ===> ________________________________________________ Scroll ===> CSR_
Select to export HDB to DB2.
Name Type Description Changed ID
_ CICSDAY LIST Today's CICS Transactions 2004/12/11 00:00 CICSPA
S CICSWEEK SUMMARY Weekly CICS Transactions 2004/12/11 00:00 CICSPA
_ CPUTREND SUMMARY Transaction CPU Usage Trend 2004/12/11 00:00 CICSPA
_ PRODRESP SUMMARY Production Transaction Response 2004/12/11 00:00 CICSPA
_ FCHIST SUMMARY File Request History 2004/12/11 00:00 CICSPA
_ PLUGINST STATS CICS PA Plugin statistics HDB 2015/10/20 10:54 CICSPA
********************************* End of list *********************************
F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel
Enter line action S to select an HDB to export from.
Tip: You can enter line action T to define the DB2 table without selecting the HDB and container. See Creating DDL to define a DB2 table for details.