Load HDBs
After defining an HDB you can collect (load) the historical data.
File Options Help
------------------------------------------------------------------------------
Load HDBs Row 1 to 5 of 5
Command ===> ________________________________________________ Scroll ===> CSR_
Select to load an HDB.
Name Type Description Changed ID
_ CICSDAY LIST Today's CICS Transactions 2004/12/11 00:00 CICSPA
S CICSWEEK SUMMARY Weekly CICS Transactions 2004/12/11 00:00 CICSPA
_ CPUTREND SUMMARY Transaction CPU Usage Trend 2004/12/11 00:00 CICSPA
_ PRODRESP SUMMARY Production Transaction Response 2004/12/11 00:00 CICSPA
_ FCHIST SUMMARY File Request History 2004/12/11 00:00 CICSPA
********************************* End of list *********************************
F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel
Enter line action S to select an HDB for Load processing. You are prompted to specify run-time options, then CICS PA will build the JCL to load data into your HDB.
You can select multiple HDBs to load in succession.
SORT and LOCATE commands are available to help you work with the list of HDBs.
Load creates the JCL that builds the HDBs. The Load process is handled via normal CICS PA command input. This allows multiple reports, extracts and HDBs to be created via a single pass of the SMF data.
The Read SMF File to EOF setting in the profile options is added as a READ2EOF operand to JCL built when the input is an SMF file and Report Interval is specified in the RUN panel.
File Systems Options Help
---------------------------------------------------------------------
Load SUMMARY HDB CICSWEEK
Command ===> ________________________________________________________
Specify HDB load options then press Enter to continue submit.
System Selection: ––––– Report Interval –––––
APPLID . . CICSPROD + YYYY/MM/DD HH:MM:SS.TH
Image . . ________ + From 0_________ 09:00:00.00
Group . . ________ + To 0_________ 16:30:00.00
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 Enter "/" to select option
/ Edit JCL before submit
F1=Help F3=Exit F4=Prompt F6=Resize F10=Actions F12=Cancel
- System Selection
- System Selection specifies the CICS® system(s)
whose data is to be loaded into the HDB. It is initialized to the CICS system APPLID that you specified
during HDB definition.
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, 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 are 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.
In this example, CICS PA generates an APPLID(CICSPROD) operand in the command deck and includes DD statements for the SMF Files defined in System Definitions for CICSPROD.
- Report Interval
- Specify the time range of data to be included in the HDB. You
can specify an explicit date, such as 2004-12-05, or a relative date
to indicate today (0), yesterday (-1), two days ago (-2), and so on.
In Figure 2 we have
used a relative date of zero (0) to indicate that we are processing
today's SMF data, from 9:00am to 4:30pm.
It is recommended that you specify relative dates if you want to use an automated job scheduler to run the load HDB JCL regularly. The JCL can be set up once and run daily without needing to change it.
- 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.
- Edit JCL before submit
- Select with a / to edit the JCL before submit. CICS PA will
generate the JCL and display it in an ISPF Edit session. You can review
or modify the JCL using the usual ISPF Edit commands and actions,
or you can use the CREATE command to save the JCL in an external data
set.
Then to submit the job, enter SUBmit in the Edit command line.
If this option is not selected, the generated JCL is not displayed and the job is submitted immediately.
After you have specified your Load options, press Enter. You are prompted to Press ENTER to proceed with request. This provides a last opportunity to review and change your load request.