Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 
.
.
Sample DPRSMFST JCL
The following BBSAMP members contain sample job control statements:
- DPRSMFB (IBM LOAD method)
- DPRSMFNB (BMC AMI Load for Db2 method)
The following figure shows the sample statements from the BBSAMP member DPRSMFB for the IBM LOAD method. For the BMC AMI Load samples, see DPRSMFNB.
//*------------------------------------------------------------*
//*JOB1 : DPRSMFST *
//* THIS JOB PROCESSES THE STATISTICS RECORDS *
//*------------------------------------------------------------*
//DPRSMFST JOB
//*
//PROCLIB JCLLIB ORDER=HIDP.BBSAMP <====UPDATE
//*
//JS010 EXEC DPPSMFA,
// PARM.STEP5='SYSTEM,UID', <====UPDATE
// PARM.STEP6='SYSTEM,UID' <====UPDATE
//*
//* STEP4 INPUT DATASETS
//*
//STEP4.STATDD DD DISP=(OLD,PASS),DSN=&RPTHI..DPDSTAT
//*
//* STEP4 OUTPUT DATASETS
//*
//STEP4.SUMMACCS DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(600,300),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.SUMMSYMB DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(600,300),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.SUMMSTAT DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(10,2),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.DDFSSTAT DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(10,2),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.BUFSSTAT DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(10,2),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//* STEP4 DPSYSIN INPUT PARAMETERS
//*
//STEP4.DPSYSIN DD *
GLOBAL LOG=NO,SSID=DDDD,INVFIELD=IGNORE,PLAN=DPSUMLD <-- UPDATE
LOAD TYPE=STAT,TABLE=DMRPR.DMRSTAT,FROMDD=STATDD
LOAD TYPE=DDFSTAT,TABLE=DMRPR.DMRSTDF,FROMDD=STATDD
LOAD TYPE=BUFSTAT,TABLE=DMRPR.DMRSBFDT,FROMDD=STATDD
* LOAD TYPE=DGBPSTAT,TABLE=DMRPR.DMRDGPDT,FROMDD=DPDDGBP
PURGE TYPE=STAT,TABLE=DMRPR.DMRSTAT,RETPD=10D
PURGE TYPE=DDFSTAT,TABLE=DMRPR.DMRSTDF,RETPD=10D
PURGE TYPE=BUFSTAT,TABLE=DMRPR.DMRSBFDT,RETPD=10D
* PURGE TYPE=DGBPSTAT,TABLE=DMRPR.DMRDGPDT,RETPD=10D
*-------------------------------------------------------------------*
*-------------------------------------------------------------------*
*
* --- LOAD SUMMARY STATISTICS TABLE (60-MINUTE INTERVAL) ---
* --- PURGE DATA THAT IS OLDER THAN 10 DAYS ---
*
SUMMARIZE TYPE=SUMSTAT,FROMDD=STATDD,
TABLE=DMRPR.DMRSTSUM,
TODD=SUMMSTAT,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION)
*
LOAD TYPE=SUMSTAT,TABLE=DMRPR.DMRSTSUM,FROMDD=SUMMSTAT
PURGE TYPE=SUMSTAT,TABLE=DMRPR.DMRSTSUM,RETPD=10D
*
* --- LOAD SUMMARY DDF STATISTICS TABLE (60-MINUTE INTERVAL)-
* --- PURGE DATA THAT IS OLDER THAN 10 DAYS ---
*
SUMMARIZE TYPE=SUMDDFSTAT,FROMDD=STATDD,
TABLE=DMRPR.DMRSDSUM,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
TODD=DDFSSTAT,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION,DDFLOCATION)
*
LOAD TYPE=SUMDDFSTAT,TABLE=DMRPR.DMRSDSUM,FROMDD=DDFSSTAT
PURGE TYPE=SUMDDFSTAT,TABLE=DMRPR.DMRSDSUM,RETPD=10D
*
* --- LOAD SUMMARY BUF STATISTICS TABLE (60-MINUTE INTERVAL)-
* --- PURGE DATA THAT IS OLDER THAN 10 DAYS ---
*
SUMMARIZE TYPE=SUMBUFSTAT,FROMDD=STATDD,
TABLE=DMRPR.DMRSBSUM,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
TODD=BUFSSTAT,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION,BPNAME)
*
LOAD TYPE=SUMBUFSTAT,TABLE=DMRPR.DMRSBSUM,FROMDD=BUFSSTAT
PURGE TYPE=SUMBUFSTAT,TABLE=DMRPR.DMRSBSUM,RETPD=10D
*-------------------------------------------------------------------*
* THE FOLLOWING STATEMENTS WILL LOAD ACCEL TABLES. *
*-------------------------------------------------------------------*
LOAD TYPE4=ACCS,TABLE=DMRPR.DMRSXDTL,FROMDD=STATDD
LOAD TYPE4=SYMB,TABLE=DMRPR.DMRSYDTL,FROMDD=STATDD
PURGE TYPE4=ACCS,TABLE=DMRPR.DMRSXDTL,RETPD=10D
PURGE TYPE4=SYMB,TABLE=DMRPR.DMRSYDTL,RETPD=10D
SUMMARIZE TYPE4=SUMACCS,FROMDD=STATDD,
TABLE=DMRPR.DMRSXSUM,
TODD=SUMMACCS,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION)
LOAD TYPE4=SUMACCS,TABLE=DMRPR.DMRSXSUM,FROMDD=SUMMACCS
PURGE TYPE4=SUMACCS,TABLE=DMRPR.DMRSXSUM,RETPD=10D
SUMMARIZE TYPE4=SUMSYMB,FROMDD=STATDD,
TABLE=DMRPR.DMRSYSUM,
TODD=SUMMSYMB,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
SUMMKEY=(BPNAME,SUBSYSTEM,SYSTEMID)
LOAD TYPE4=SUMSYMB,TABLE=DMRPR.DMRSYSUM,FROMDD=SUMMSYMB
PURGE TYPE4=SUMSYMB,TABLE=DMRPR.DMRSYSUM,RETPD=10D
/*
//*
//* STEP4 DFSPARM
//*
//STEP4.DFSPARM DD *
LIST,LISTX,MOSIZE=MAX,HIPRMAX=OPTIMAL,DSPSIZE=MAX,SIZE=MAX,
DYNALLOC=(WORK,24),DYNAPCT=50,DYNSPC=1024MB,FILSZ=E04444440,DSA=MAX
/*
//*
//*
//* STEP5 INPUT DATASETS
//*
//STEP5.STATDD DD DISP=(OLD,PASS),DSN=&RPTHI..DPDSTAT
//STEP5.SUMMSTAT DD DISP=(OLD,DELETE),DSN=*.STEP4.SUMMSTAT
//STEP5.DDFSSTAT DD DISP=(OLD,DELETE),DSN=*.STEP4.DDFSSTAT
//STEP5.BUFSSTAT DD DISP=(OLD,DELETE),DSN=*.STEP4.BUFSSTAT
//STEP5.SUMMACCS DD DISP=(OLD,DELETE),DSN=*.STEP4.SUMMACCS
//STEP5.SUMMSYMB DD DISP=(OLD,DELETE),DSN=*.STEP4.SUMMSYMB
//*STEP5.DPDDGBP DD DISP=(OLD,PASS),DSN=&RPTHI..DPDDGBP
//*
//* STEP5 DFSPARM
//*
//STEP5.DFSPARM DD *
LIST,LISTX,MOSIZE=MAX,HIPRMAX=OPTIMAL,DSPSIZE=MAX,SIZE=MAX,
DYNALLOC=(WORK,24),DYNAPCT=50,DYNSPC=1024MB,FILSZ=E04444440,DSA=MAX
/*
//*
//* DELETE DATASETS
//*
//STEP7.STATDD DD DISP=(OLD,DELETE,DELETE),DSN=&RPTHI..DPDSTAT
//*STEP7.DPDDGBP DD DISP=(OLD,DELETE,DELETE),DSN=&RPTHI..DPDDGBP
//
//*JOB1 : DPRSMFST *
//* THIS JOB PROCESSES THE STATISTICS RECORDS *
//*------------------------------------------------------------*
//DPRSMFST JOB
//*
//PROCLIB JCLLIB ORDER=HIDP.BBSAMP <====UPDATE
//*
//JS010 EXEC DPPSMFA,
// PARM.STEP5='SYSTEM,UID', <====UPDATE
// PARM.STEP6='SYSTEM,UID' <====UPDATE
//*
//* STEP4 INPUT DATASETS
//*
//STEP4.STATDD DD DISP=(OLD,PASS),DSN=&RPTHI..DPDSTAT
//*
//* STEP4 OUTPUT DATASETS
//*
//STEP4.SUMMACCS DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(600,300),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.SUMMSYMB DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(600,300),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.SUMMSTAT DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(10,2),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.DDFSSTAT DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(10,2),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//STEP4.BUFSSTAT DD UNIT=&UNIT,DISP=(,PASS),SPACE=(CYL,(10,2),RLSE),
// DCB=(LRECL=2048,BLKSIZE=27998,RECFM=VB)
//*
//* STEP4 DPSYSIN INPUT PARAMETERS
//*
//STEP4.DPSYSIN DD *
GLOBAL LOG=NO,SSID=DDDD,INVFIELD=IGNORE,PLAN=DPSUMLD <-- UPDATE
LOAD TYPE=STAT,TABLE=DMRPR.DMRSTAT,FROMDD=STATDD
LOAD TYPE=DDFSTAT,TABLE=DMRPR.DMRSTDF,FROMDD=STATDD
LOAD TYPE=BUFSTAT,TABLE=DMRPR.DMRSBFDT,FROMDD=STATDD
* LOAD TYPE=DGBPSTAT,TABLE=DMRPR.DMRDGPDT,FROMDD=DPDDGBP
PURGE TYPE=STAT,TABLE=DMRPR.DMRSTAT,RETPD=10D
PURGE TYPE=DDFSTAT,TABLE=DMRPR.DMRSTDF,RETPD=10D
PURGE TYPE=BUFSTAT,TABLE=DMRPR.DMRSBFDT,RETPD=10D
* PURGE TYPE=DGBPSTAT,TABLE=DMRPR.DMRDGPDT,RETPD=10D
*-------------------------------------------------------------------*
*-------------------------------------------------------------------*
*
* --- LOAD SUMMARY STATISTICS TABLE (60-MINUTE INTERVAL) ---
* --- PURGE DATA THAT IS OLDER THAN 10 DAYS ---
*
SUMMARIZE TYPE=SUMSTAT,FROMDD=STATDD,
TABLE=DMRPR.DMRSTSUM,
TODD=SUMMSTAT,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION)
*
LOAD TYPE=SUMSTAT,TABLE=DMRPR.DMRSTSUM,FROMDD=SUMMSTAT
PURGE TYPE=SUMSTAT,TABLE=DMRPR.DMRSTSUM,RETPD=10D
*
* --- LOAD SUMMARY DDF STATISTICS TABLE (60-MINUTE INTERVAL)-
* --- PURGE DATA THAT IS OLDER THAN 10 DAYS ---
*
SUMMARIZE TYPE=SUMDDFSTAT,FROMDD=STATDD,
TABLE=DMRPR.DMRSDSUM,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
TODD=DDFSSTAT,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION,DDFLOCATION)
*
LOAD TYPE=SUMDDFSTAT,TABLE=DMRPR.DMRSDSUM,FROMDD=DDFSSTAT
PURGE TYPE=SUMDDFSTAT,TABLE=DMRPR.DMRSDSUM,RETPD=10D
*
* --- LOAD SUMMARY BUF STATISTICS TABLE (60-MINUTE INTERVAL)-
* --- PURGE DATA THAT IS OLDER THAN 10 DAYS ---
*
SUMMARIZE TYPE=SUMBUFSTAT,FROMDD=STATDD,
TABLE=DMRPR.DMRSBSUM,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
TODD=BUFSSTAT,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION,BPNAME)
*
LOAD TYPE=SUMBUFSTAT,TABLE=DMRPR.DMRSBSUM,FROMDD=BUFSSTAT
PURGE TYPE=SUMBUFSTAT,TABLE=DMRPR.DMRSBSUM,RETPD=10D
*-------------------------------------------------------------------*
* THE FOLLOWING STATEMENTS WILL LOAD ACCEL TABLES. *
*-------------------------------------------------------------------*
LOAD TYPE4=ACCS,TABLE=DMRPR.DMRSXDTL,FROMDD=STATDD
LOAD TYPE4=SYMB,TABLE=DMRPR.DMRSYDTL,FROMDD=STATDD
PURGE TYPE4=ACCS,TABLE=DMRPR.DMRSXDTL,RETPD=10D
PURGE TYPE4=SYMB,TABLE=DMRPR.DMRSYDTL,RETPD=10D
SUMMARIZE TYPE4=SUMACCS,FROMDD=STATDD,
TABLE=DMRPR.DMRSXSUM,
TODD=SUMMACCS,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
SUMMKEY=(SUBSYSTEM,SYSTEMID,LOCATION)
LOAD TYPE4=SUMACCS,TABLE=DMRPR.DMRSXSUM,FROMDD=SUMMACCS
PURGE TYPE4=SUMACCS,TABLE=DMRPR.DMRSXSUM,RETPD=10D
SUMMARIZE TYPE4=SUMSYMB,FROMDD=STATDD,
TABLE=DMRPR.DMRSYSUM,
TODD=SUMMSYMB,
SUMMSTART=*_1,
SUMMEND=*,
SUMMINT=60M,
SUMMKEY=(BPNAME,SUBSYSTEM,SYSTEMID)
LOAD TYPE4=SUMSYMB,TABLE=DMRPR.DMRSYSUM,FROMDD=SUMMSYMB
PURGE TYPE4=SUMSYMB,TABLE=DMRPR.DMRSYSUM,RETPD=10D
/*
//*
//* STEP4 DFSPARM
//*
//STEP4.DFSPARM DD *
LIST,LISTX,MOSIZE=MAX,HIPRMAX=OPTIMAL,DSPSIZE=MAX,SIZE=MAX,
DYNALLOC=(WORK,24),DYNAPCT=50,DYNSPC=1024MB,FILSZ=E04444440,DSA=MAX
/*
//*
//*
//* STEP5 INPUT DATASETS
//*
//STEP5.STATDD DD DISP=(OLD,PASS),DSN=&RPTHI..DPDSTAT
//STEP5.SUMMSTAT DD DISP=(OLD,DELETE),DSN=*.STEP4.SUMMSTAT
//STEP5.DDFSSTAT DD DISP=(OLD,DELETE),DSN=*.STEP4.DDFSSTAT
//STEP5.BUFSSTAT DD DISP=(OLD,DELETE),DSN=*.STEP4.BUFSSTAT
//STEP5.SUMMACCS DD DISP=(OLD,DELETE),DSN=*.STEP4.SUMMACCS
//STEP5.SUMMSYMB DD DISP=(OLD,DELETE),DSN=*.STEP4.SUMMSYMB
//*STEP5.DPDDGBP DD DISP=(OLD,PASS),DSN=&RPTHI..DPDDGBP
//*
//* STEP5 DFSPARM
//*
//STEP5.DFSPARM DD *
LIST,LISTX,MOSIZE=MAX,HIPRMAX=OPTIMAL,DSPSIZE=MAX,SIZE=MAX,
DYNALLOC=(WORK,24),DYNAPCT=50,DYNSPC=1024MB,FILSZ=E04444440,DSA=MAX
/*
//*
//* DELETE DATASETS
//*
//STEP7.STATDD DD DISP=(OLD,DELETE,DELETE),DSN=&RPTHI..DPDSTAT
//*STEP7.DPDDGBP DD DISP=(OLD,DELETE,DELETE),DSN=&RPTHI..DPDDGBP
//
Failed to execute the [panel] macro. Cause: [Missing macro content: this macro requires content (a body)]. Click on this message for details.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*