169
« on: January 13, 2012, 09:24:48 AM »
Note: The .profile associated with the userid I run these jobs under has both DB2 and CMOD in the STEPLIB concatenation. I don't know if that makes a difference or not, but FYI.
//DROPINDX JOB
//JOBLIB DD DISP=SHR,DSN=ARS.ARSV850.SARSLOAD
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNEXIT
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNLOAD
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNLOD2
//STEP1 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 starting drop index run
/*
//STEP2 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 drop indexes ARSUSRGRP
/*
//STEP3 EXEC PGM=BPXBATCH,REGION=0M,
// PARM='PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -efv ARSUSRGRP'
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDIN DD PATH='/ars/tmp/yes',PATHOPTS=(ORDONLY)
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP4 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 drop indexes ARSLOAD
/*
//STEP5 EXEC PGM=BPXBATCH,REGION=0M,
// PARM='PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -efv ARSLOAD'
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDIN DD PATH='/ars/tmp/yes',PATHOPTS=(ORDONLY)
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP6 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 drop indexes ARSNODE
/*
//STEP7 EXEC PGM=BPXBATCH,REGION=0M,
// PARM='PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -efv ARSNODE'
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDIN DD PATH='/ars/tmp/yes',PATHOPTS=(ORDONLY)
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP8 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 drop indexes ARSAPP
/*
//STEP9 EXEC PGM=BPXBATCH,REGION=0M,
// PARM='PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -efv ARSAPP'
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDIN DD PATH='/ars/tmp/yes',PATHOPTS=(ORDONLY)
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP10 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 ending drop indexes
/*
//MAKEINDX JOB
//JOBLIB DD DISP=SHR,DSN=ARS.ARSV850.SARSLOAD
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNEXIT
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNLOAD
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNLOD2
//STEP1 EXEC PGM=IKJEFT01,
// DYNAMNBR=200
//SYSPROC DD DSN=SYS1.SBPXEXEC,DISP=SHR
//*
//SYSTSPRT DD SYSOUT=*
//*
//SYSTSIN DD *
oshell /bin/logger -d1 starting make index run
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP2 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /bin/logger -d1 make indexes ARSUSRGRP
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP3 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -rv ARSUSRGRP
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP4 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /bin/logger -d1 make indexes ARSLOAD
//STDENV DD *
/*
//STEP5 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -rv ARSLOAD
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP6 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /bin/logger -d1 make indexes ARSNODE
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP7 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -rv ARSNODE
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP8 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /bin/logger -d1 make indexes ARSAPP
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP9 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -rv ARSAPP
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//STEP10 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /bin/logger -d1 ending make index run
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//UPDSTATS JOB
//JOBLIB DD DISP=SHR,DSN=ARS.ARSV850.SARSLOAD
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNEXIT
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNLOAD
// DD DISP=SHR,DSN=DSN.DB2VA10.SDSNLOD2
//STEP3 EXEC PGM=BPXBATCH,REGION=0M
//*
//*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//STDPARM DD *
PGM /usr/lpp/ars/V8R5M0/bin/arsdb -I ARCH850 -mv
//STDENV DD *
_BPXK_JOBLOG=STDERR
/*
//*