HDB(LOAD) examples
The following job is provided as member CPAHDB in the sample library SCPASAMP. This JCL runs the SMF Dump process, followed by Shared System Take-up from an SMF file, HDB Load, and selected reports. By combining take-up, HDB load and reporting into a single job step, all CICS PA functions can be performed by a single pass of the SMF data.
//CPAHDB JOB ,CLASS=A,NOTIFY=&SYSUID
//* SMF Dump
//SMFDUMP EXEC PGM=IFASMFDP
//INDD DD DSN=SYS1.MAN1,DISP=SHR
//OUTDD1 DD DISP=(NEW,CATLG),DSN=CICSPROD.SMFDAILY(+1)
//SYSPRINT DD SYSOUT=A
//SYSIN DD *
INDD(INDD,OPTIONS(ALL))
OUTDD(OUTDD1,TYPE(110))
/*
//*
//* CICS PA Take-up, HDB Load, and selected reports
//CICSPA EXEC PGM=CPAMAIN,REGION=4M,PARM=NOSTAE
//STEPLIB DD DSN=CPA.V5R3M0.SCPALINK,DISP=SHR
//SYSPRINT DD SYSOUT=*
//* SMF Input Files
//SMFIN001 DD DISP=(SHR,KEEP),DSN=CICSPROD.SMFDAILY(+1)
//* Repository
//CPAHDBRG DD DISP=SHR,DSN=USER.CICSPA.XYX.REPOSTRY
//*
//* CICS PA command requests
//SYSIN DD *
CICSPA IN(SMFIN001),
APPLID(*),
* Take-up from SMF into Shared System Definitions
HDB(TAKEUP,SYSTEMS,FILESYSTEM,OUTPUT(TAKEUP)),
* HDB Load requests
HDB(LOAD(WEEKLY),OUTPUT(WEEKLY)),
HDB(LOAD(DAILY),OUTPUT(DAILY)),
HDB(LOAD(STATS),OUTPUT(STATS)),
* CMF Performance Report requests
SUMMARY(FIELDS(TRAN),OUTPUT(SUMM0001)),
WAITANAL(BY(TRAN),OUTPUT(WAIT0001))
/*
Successful completion of the Load request generates a Recap report
that provides information about the HDB Load, including a list of
container data sets created by the Load process.
Figure 1. HDB Load Recap report
In this example, CICS PA created
container data set CPA.WEEKLY.D03219.T092846.HDB for HDB WEEKLY. It
contains 54,567 records for the period 9:00am to 4:00pm on August
7, 2004. V5R3M0 CICS Performance Analyzer
HDB Load Recap Report
WEEKLY Printed at 9:28:48 8/08/2004 Data from 09:02:00 8/07/2004 to 16:29:00 8/07/2004 Page 1
LOAD requested for HDB: WEEKLY Repository DSN: USER.CICSPA.XYX.REPOSTRY
The following Containers were created and loaded:
Container DSN: CPA.WEEKLY.D03219.T092846.HDB No of Records: 54,567
Start Time Stamp: 2004-08-07-09.00.00 End Time Stamp: 2004-08-07-16.00.00
LOAD process complete.