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 this example, 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 V5R1 HDB LOAD JCL
000003 //CICSPA EXEC PGM=CPAMAIN
000004 //STEPLIB DD DSN=CPA.V5R1M0.SCPALINK,DISP=SHR
000005 //CPAHDBRG DD DSN=CICSPROD.CICSPA.HDB.REPOSTRY,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. V5R1M0 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 Repository DSN: CICSPROD.CICSPA.XYZ.REPOSTRY
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.