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.
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
.


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
********************************* End of list *********************************
F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel