After defining the HDB, you can start to collect (load) the historical statistics data.
File Options Help ------------------------------------------------------------------------------ Load HDBs Row 1 to 1 of 1 Command ===> ________________________________________________ Scroll ===> CSR_ Select to load an HDB. Name Type Description Changed ID S CICSP1S STATS Statistics HDB for CICSP1 2004/12/06 16:02 JCH ********************************* End of list ********************************* F1=Help F3=Exit F7=Backward F8=Forward F10=Actions F12=Cancel
File Systems Options Help --------------------------------------------------------------------- Load STATS HDB - CICSP1S Command ===> ________________________________________________________ Specify HDB load options then press Enter to continue submit. System Selection: ––––– Report Interval ––––– APPLID . . CICSP1S_ + 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
In the example above, CICS PA generates an APPLID(CICSP1) operand in the command deck and includes DD statements for the SMF Files defined in System Definitions for CICSP1.
Note that EOD statistics are often cut at midnight, so would not be included in this HDB.
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.
When you have specified your Load options, you are prompted to Press ENTER to proceed with request. This provides a last opportunity to review and change your load request.
EDIT JCH.SPFTEMP1.CNTL Columns 00001 00072 Command ===> change '<unresolved>' 'CICSP1.DAILY.CMF(0)'__ Scroll ===> CSR_ ****** ***************************** Top of Data ****************************** 000001 //CICSPA JOB ,NOTIFY=&SYSUID 000002 //* CICS PA V3R2 HDB LOAD JCL 000003 //CICSPA EXEC PGM=CPAMAIN 000004 //STEPLIB DD DSN=CPA.V3R2M0.SCPALINK,DISP=SHR 000005 //CPAHDBRG DD DSN=CICSPROD.CICSPA.HDB.REGISTER,DISP=SHR 000006 //SYSPRINT DD SYSOUT=* 000007 //* SMF Input Files 000008 //* SMF Files that follow have unresolved DSNs 000009 //* SMF File for System=CICSP1 000010 //SMFIN901 DD DSN=<unresolved>,DISP=SHR 000011 //* Command Input 000012 //SYSIN DD * 000013 * HDB=CICSP1S 000014 * Description=Summary HDB for CICSP1 000015 CICSPA SMFSTART(0,09:00:00.00), 000016 SMFSTOP(0,16:30:00.00) 000017 * HDB Load for System=CICSP1 000018 CICSPA IN(SMFIN901), 000019 APPLID(CICSP1), 000020 LINECNT(60), 000021 FORMAT(':','/'), 000022 HDB(OUTPUT(HDBL0001),LOAD(CICSP1S)) 000023 /*
The SMF file data set name for system CICSP1 might be unresolved. This indicates that the System Definition for CICSP1 does not have SMF files specified. Substitute the required SMF file data set name into the JCL.
HDB(OUTPUT(HDBL0001),LOAD(CICSP1S))
Enter SUBmit in
the command line to submit the job to run the load. V3R2M0 CICS Performance Analyzer
HDB Load Recap Report
HDBL0001 Printed at 9:28:48 15/03/2005 Data from 09:00:00 15/03/2005 to 16:30:00 15/03/2005 Page 1
LOAD requested for HDB: CICSP1S Register DSN: CICSPROD.CICSPA.HDB.REGISTER
The following Container(s) were created and loaded:
Container DSN: CICSPA.CICSP1S.D03219.T092846.HDB No of Records: 54,567
Start Time Stamp: 2005-03-15-09.00.00 End Time Stamp: 2005-03-15-16.00.00
LOAD process complete.