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.
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
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.
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.
In the example above, 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.
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.
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.
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.