Cat/Dir REORG JCLs Part 3 - RCVRCATP

Michael Ebert

Cat/Dir REORG JCLs Part 3 - RCVRCATP
Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany
Tel. ++49 -8122-433962
Fax ++49-8122-433260


//OBO025RC JOB (USERJOB,ME),'DB2 UTILITY',CLASS=Y,MSGCLASS=X,
// REGION=6M,NOTIFY=&SYSUID,TYPRUN=HOLD
/*JOBPARM SYSAFF=AMAB
//*
//*=====================
//*
//* RECOVER Job for DB2P Catalog/Directory
//* See UTILITIES Guide, p. 2-177 f.
//*
//*=====================
//*
//*---------------------------------------------------------------------
//TERMUTIL EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2P)
-TER UTIL(OBO025.RECOVER)
//*---------------------------------------------------------------------
//SYSUTILX EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB01.SYSUTILX
//*---------------------------------------------------------------------
//DBD01 EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB01.DBD01
//*---------------------------------------------------------------------
//IDXUTILX EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNLUX01,SYSIBM.DSNLUX02) SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//SYSCOPY EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB06.SYSCOPY
//*---------------------------------------------------------------------
//IDXCOPY EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNUCH01,SYSIBM.DSNUCX01) SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//SYSLGRNX EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB01.SYSLGRNX
//*---------------------------------------------------------------------
//IDXLGRNX EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNLLX01,SYSIBM.DSNLLX02) SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//SYSDBAUT EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB06.SYSDBAUT
//*---------------------------------------------------------------------
//IDXDBAUT EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNADH01,SYSIBM.DSNADX01,SYSIBM.DSNDDH01,
SYSIBM.DSNDDX02) SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//SYSUSER EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB06.SYSUSER
//*---------------------------------------------------------------------
//SYSDBASE EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB06.SYSDBASE
//*---------------------------------------------------------------------
//IDXUSER EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNAUH01,SYSIBM.DSNAUX02) SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//IDXDBASE EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNATX01,SYSIBM.DSNATX02,SYSIBM.DSNATX03,
SYSIBM.DSNDCX01,SYSIBM.DSNDKX01,SYSIBM.DSNDLX01,
SYSIBM.DSNDPX01,SYSIBM.DSNDRX01,SYSIBM.DSNDSX01,
SYSIBM.DSNDTX01,SYSIBM.DSNDTX02,SYSIBM.DSNDXX01,
SYSIBM.DSNDXX02,SYSIBM.DSNDXX03,SYSIBM.DSNDYX01)
SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//SYSOTHER EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER TABLESPACE DSNDB01.SCT02
RECOVER TABLESPACE DSNDB01.SPT01
RECOVER TABLESPACE DSNDB06.SYSDDF
RECOVER TABLESPACE DSNDB06.SYSGPAUT
RECOVER TABLESPACE DSNDB06.SYSGROUP
RECOVER TABLESPACE DSNDB06.SYSPKAGE
RECOVER TABLESPACE DSNDB06.SYSPLAN
RECOVER TABLESPACE DSNDB06.SYSSTATS
RECOVER TABLESPACE DSNDB06.SYSSTR
RECOVER TABLESPACE DSNDB06.SYSVIEWS
//*---------------------------------------------------------------------
//IDXOTHER EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD *
RECOVER INDEX(SYSIBM.DSNSCT02) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNSPT01,SYSIBM.DSNSPT02) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNFCX01,SYSIBM.DSNFDX01,SYSIBM.DSNFEX01,
SYSIBM.DSNFLX01,SYSIBM.DSNFLX02,SYSIBM.DSNFMX01,
SYSIBM.DSNFNX01,SYSIBM.DSNFPX01) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNAGH01,SYSIBM.DSNAGX01) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNSSH01) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNKAX01,SYSIBM.DSNKAX02,SYSIBM.DSNKAX03,
SYSIBM.DSNKCX01,SYSIBM.DSNKDX01,SYSIBM.DSNKDX02,
SYSIBM.DSNKKX01,SYSIBM.DSNKKX02,SYSIBM.DSNKLX01,
SYSIBM.DSNKLX02,SYSIBM.DSNKPX01,SYSIBM.DSNKSX01,
SYSIBM.DSNKYX01) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNAPH01,SYSIBM.DSNAPX01,SYSIBM.DSNGGX01,
SYSIBM.DSNPPH01) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNTCX01,SYSIBM.DSNTNX01,SYSIBM.DSNTPX01,
SYSIBM.DSNTTX01,SYSIBM.DSNTXX01) SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNSCX01,SYSIBM.DSNSDX01,SYSIBM.DSNSSX01)
SORTDEVT 3390 SORTNUM 3
RECOVER INDEX(SYSIBM.DSNGGX02,SYSIBM.DSNVTH01,SYSIBM.DSNVVX01)
SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------
//USERDEF EXEC PGM=DSNUTILB,COND=(4,LT),PARM='DB2P,OBO025.RECOVER'
//SYSPRINT DD SYSOUT=*
//UTPRINT DD SYSOUT=*
//SYSIN DD * list user-defined indexes on the Cat/Dir here!
RECOVER INDEX(DB2PADM.DSNDSX02,DB2PADM.DSNDSX03,DB2PADM.DSNDTX04)
SORTDEVT 3390 SORTNUM 3
//*---------------------------------------------------------------------