Sample Jobs To Run z/OS 8.5.0.4 ACTION HOLD In Batch

Ed_Arnold · January 13, 2012, 04:24:48 PM

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
/*
//*

Ed_Arnold · January 13, 2012, 04:49:16 PM

Forgot to mention - the contents of /ars/tmp/yes/ is simply a "y" to respond to the prompt as to whether you really want to drop those indexes or not.

BROWSE /ars/tmp/yes
Command ===>
********************************* Top of Data ***
y
******************************** Bottom of Data *

Sample Jobs To Run z/OS 8.5.0.4 ACTION HOLD In Batch

Ed_Arnold

Ed_Arnold