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 HDB Register is CPAHDBRG. Specify the name of the HDB to be loaded. Press Prompt (F4) to select from a list of HDBs in the current HDB Register.

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_  +                                  
  HDB Register  . : CICSPA.HDB.REGISTER                         
                                                                 
 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 HDB Register, 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
Identifies the CICS APPLID(s) whose data you want to select for processing.

You can specify any combination of APPLID, Image, or Group, but these must be defined in your System Definitions. If you do not specify System Selection here or in the Global Options, then you are prompted at run time to specify the System Selection. This will apply globally to all reports and extracts without their own System Selection. This is recommended as it allows you to run your Report Sets against any of your defined Systems. Press the Prompt key (F4) to select from a list of defined Systems, Images, or Groups. To modify your System Definitions, select Systems in the action bar.

Specify one of the following:
  • A CICS APPLID. An APPLID that matches a defined System's name pattern is also allowed. For example, CICSP1 can be specified if CICSP* is a defined system.
  • An APPLID and an MVS™ Image. This identifies the MVS Image where your CICS system runs.
  • An MVS Image. All CICS systems executing on this MVS Image is selected.
  • An APPLID and Image combination plus a Group. This is useful for uniquely identifying a CICS system when there are multiple CICS systems with the same name defined.
  • A Group alone. CICS PA will select all CICS APPLIDs defined to the Group. For example, for transaction grouping, or for systems that connect via IRC/MRO, ISC/APPC, or IPIC.

CICS PA uses the System Selection in JCL generation to build the APPLID(applid1,applid2,applid3,...) and INput(SMFIN001,SMFIN002,SMFIN003,...) operands, and corresponding //SMFINnnn DD statements.

System Selection can also be specified either:
  • In Global Options. The report-level specification takes precedence over the global.
  • At run time. The run-time System Selection overrides the Global Options and optionally the report-level specification.
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 HDB Register.

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

DB2® Export Options
To export the data to DB2 directly after loading it into the HDB, select the Load DB2 Table option. For details of the JCL that this option generates, see Load JCL. (The remaining DB2 export options are only relevant if you select the Load DB2 Table option.)

The DB2 table to which you are exporting must already be defined.

To define a DB2 table, see Creating DDL to define a DB2 table.

If you select 2. Replace for Table Load Options and the HDB load fails, then the result is an empty DB2 table.