/ ADD NAME=&JOBNAME
//&JOBNAME JOB (XXX),RUNSTAT,MSGCLASS=X,REGION=8M,TIME=1440,
// MSGLEVEL=(1,1) ,TYPRUN=SCAN
//*
//*
//TERM EXEC PGM=IKJEFT01
//STEPLIB DD DSN=DB2.&DB2SYS..SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(&DB2SYS)
-TERM UTIL(&JOBNAME)
END
//*
//UTIL EXEC DSNUPROC,SYSTEM=&DB2SYS,REGION=8M,UID=&JOBNAME,UTPROC=,
// LIB='DB2.&DB2SYS..SDSNLOAD'
//***************************************************************
//* THIS JOB RUNS THE RUNSTATS UTILITY AGAINST INDEXES
//***************************************************************
//*
//DSNUPROC.SYSIN DD *
)BLANK
OPTIONS EVENT(ITEMERROR,SKIP)
)BLANK
LISTDEF IXLIST
)DOT OBJS
INCLUDE TABLESPACE &ONAME1..&ONAME2
)ENDDOT
)BLANK 2
RUNSTATS TABLESPACE LIST IXLIST
TABLE(ALL) INDEX(ALL)
SHRLEVEL CHANGE
UPDATE ALL REPORT NO HISTORY NONE
/*
//TERM EXEC PGM=IKJEFT01,COND=ONLY
//STEPLIB DD DSN=DB2.&DB2SYS..SDSNLOAD,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(&DB2SYS)
-TERM UTIL(&JOBNAME)
END
//*