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.