Select option 5 Export from the HDB menu to export HDB data into DB2®.
Unlike Performance HDBs, Statistics HDBs do not have a common record format. The records for each statistics report (or type, as identified by its CICS® domain and statistics ID) have a different record format. Therefore one DB2 table must be defined for each type of statistics record to be exported.
File Options Help
------------------------------------------------------------------------------
Export HDBs Row 1 to 1 of 1
Command ===> ________________________________________________ Scroll ===> CSR_
Select to export HDB to DB2.
Name Type Description Changed ID
S CICSP1S STATS Statistics HDB for CICSP1 2005/03/16 12:23 JCH
********************************* End of list *********************************
F1=Help F3=Exit F5=Rfind F7=Backward F8=Forward F10=Actions
F12=Cancel
File Options Help
-------------------------------------------------------------------------------
Export STATS HDB - CICSP1S Row 1 to 2 of 2
Command ===> ________________________________________________ Scroll ===> PAGE
Select to export HDB data sets to DB2.
HDB Name . . : CICSP1S Type . . : STATS
Data Set Name ------ Start ------ Volume
S CICSPA.CICSP1.D05074.T102306.HDB 2005/03/15 07:00:00 USER05
S CICSPA.CICSP1.D05074.T152311.HDB 2005/03/15 14:00:00 USER05
S CICSPA.CICSP1.D05075.T042316.HDB 2005/03/16 02:00:00 USER05
****************************** Bottom of data ******************************
File Edit Options View Help
------------------------------------------------------------------------------
EXPORT Statistics Reports Line 1 of 25
Command ===> ________________________________________________ Scroll ===> CSR_
Select reports to export to DB2.
DB2
___ ** Reports ** Collect Load
- ___ Regions Yes No
___ Transaction Manager Yes No
- ___ CICS Dispatcher Yes No
___ Dispatcher Overview Yes No
___ Dispatcher TCB Modes Yes No
___ Dispatcher TCB Pools Yes No
___ MVS TCB Overview Yes No
___ MVS TCBs Yes No
- ___ CICS Storage Yes No
___ Storage Overview Yes No
S__ DSAs Yes No
___ Domain Subpools Yes No
___ Task Subpools Yes No
+ ___ CICS Dumps Yes No
___ Enqueue Pools Yes No
___ BUNDLE Resources No No
+ ___ Connectivity No No
+ ___ Files and Databases No No
+ ___ Logging No No
+ ___ Queues No No
+ ___ Transactions No No
+ ___ Programs No No
+ ___ CICS Web Support No No
+ ___ Java and Enterprise Java No No
+ ___ Miscellaneous No No
+ ___ CICS Server No No
+ ___ CICS Transaction Gateway No No
** End of Reports **
Enter line action S to select the reports that you want to export to DB2.
Only the reports that you select are exported to DB2. The DB2 Load column is ignored: this column is only used when loading the HDB with the Load DB2 Table option selected.
In the following example, we have selected the DSAs report.