HDB Load
- Reports and HDB Load in the one job
- Multiple load requests supported in the one job
- One pass of the data
A Recap report containing processing statistics is always printed at the end of load processing.
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.
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.
- System Selection
-
- CICS® APPLID
- Identifies the CICS APPLIDs 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 repository.
The current repository 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.