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.

Select option 5 Export from the HDB menu to export HDB data into a DB2 table.
Figure 1. HDB exporting
  File  Explorer  Options  Help                                               
------------------------------------------------------------------------------
                                HDB Exporting                  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  

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///users-guide/hdbexport.htm