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.
Statistics HDB data is used for both short-term problem analysis and long-term trend analysis. Like List HDBs, take care when exporting Statistics HDBs into DB2. The volume of data can be high, resulting in a table that is too large to manage.
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 CICSP1H SUMMARY Summary HDB for CICSP1 2004/12/07 15:25 JCH
********************************* End of list *********************************
F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel
File Options Help
------------------------------------------------------------------------------
Export SUMMARY HDB - CICSP1H Row 1 to 1 of 1
Command ===> ________________________________________________ Scroll ===> CSR_
Export HDB data set.
Name . . : CICSP1H
Data Set Name Start Volume
S JCH.CICSP1H.D03219.T092846.HDB 2004/12/07 09:00:00 USER01
********************************* End of list *********************************
F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel
File Options Help
-----------------------------------------------------------------------
Export HDB Data Set
Command ===> __________________________________________________________
HDB Name . . . : CICSP1H
Data Set Name . : JCH.CICSP1H.D03219.T092846.HDB
Select option
1 1. Create DDL to define table 2. Load data into table
Create Options Load Options
_ Create Database 1 1. Resume
_ Create Storage Group 2. Replace
DB2 Settings:
DB2 Subsystem ID . . . DB2P
DSNTIAD Plan Name . . DSNTIA91
DB2 Load Library . . . 'DB2.V910.SDSNLOAD'___________________________
DB2 Exit Library . . . 'DB2.V910.SDSNEXIT'___________________________
DB2 RUNLIB Library . . 'DB2.V910.RUNLIB.LOAD'________________________
Database . . . . . . . CICSPA__ Storage Group . . SYSDEFLT
VCAT Catalog name . . USER____ Volume . . . . . . DA0001
Allocation: Primary 20______ Secondary . . . . 20____
Include Clock Field Components Summary Options
1 1. Time and Count / Include Sums of Squares
2. Time only
3. Count only
F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel