HDB Load

The HDB Load is a facility that loads SMF data into a Historical Database (HDB). This same facility is available from Primary Menu option 5 Historical Database. However, from Report Sets you have the advantages of:

A Recap report containing processing statistics is always printed at the end of load processing.

To request HDB Load, enter line action S against HDB Load in the Extracts category on the Report Set panel. If HDB Loads have been previously specified in this Report Set, the list of them is displayed. Otherwise, the HDB Load panel is displayed for you to request your first one.
Figure 1. HDB Loads
   File  Filter  Edit  Systems  Options  Help
 ------------------------------------------------------------------------------
                             SAMPLE - HDB Loads       	             Row 1 from 1
 Command ===> ________________________________________________ Scroll ===> ____
 
         ---- System Selection -----                     
 /  Exc  APPLID +  Image +  Group +     Recap      HDB + 
 _       CICSP001  ________ ________    HDBL0001   LISTHDB_
 ******************************** Bottom of data *****************************
 

This panel displays the list of HDB Load requests in this Report Set. You can select (edit), delete, or include/exclude any in the list, insert new ones, or rearrange them (move/copy).

The options and line actions are the same as on the Cross-System Work Extracts panel, except Selection Criteria and Output Data Set are not applicable here. See Cross-System Work extract.

The default DDname for the Recap report output is HDBLnnnn where nnnn is a sequential number 0001-9999 to ensure uniqueness.

The default DDname for the Repository is CPAHDBRG. Specify the name of the HDB to be loaded. Press Prompt (F4) to select from a list of HDBs in the current Repository.

To display the HDB Load panel, enter line action S to select from the list.
Figure 2. HDB Load
   File  Systems  Options  Help
 ------------------------------------------------------------------------------
                             SAMPLE - HDB Load
 Command ===> _________________________________________________________________
 
 System Selection:                       Extract Recap:          
  APPLID . . ________  +                  DDname  . . . HDBL0001 
  Image  . . ________  +                                         
  Group  . . ________  +                                         
                                                                 
 Historical Database:                                            
  HDB . . . . . . . #LIST01_  +                                  
  Repository  . . : CICSPA.XYX.REPOSTRY                         
                                                                 
 DB2 Export Options:                     Table Load Options        
 _  Load DB2 Table                       1  1. Resume   2. Replace 
                                                                   
 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      F4=Prompt    F7=Backward  F8=Forward  F10=Actions
 F12=Cancel

Use this panel to specify the load options, including system selection, the name of the HDB in the current repository, and the DDname for the Recap report.

Specify the systems that you want to analyze. The systems and files must be defined in System Definitions. You can link directly there by selecting Systems in the action bar. It is recommended that you specify your System Selection at run time, not within the Report Set. This will allow you to load data from any of your defined systems.

To run the load, enter the RUN command.

The options are:
System Selection
CICS® APPLID
Extract Recap DDname
The DDname for the Recap report which prints at the end of load processing to provide processing statistics. The DDname is mandatory.

CICS PA assigns a default DDname HDBLnnnn where nnnn is a sequential number 0001-9999 to ensure each Recap report has a unique DDname.

This option generates the OUTPUT(ddname) operand.

Historical Database
Specify the name of the HDB you want to load with SMF data. Press Prompt (F4) to select an HDB from the current repository.

The current repository is specified in option 5 Historical Database from the Primary Option Menu.


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


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