Example 16: Using MAXKSORT and recovering a table space

Example 16 illustrates the recovery of a table space and the use of the MAXKSORT option to invoke parallel index sorts and rebuilds for the partitioned index and the nonpartitioned indexes.

//AFREX17  JOB (PAFR),'EXAMPLE 16', 
//         CLASS=Q,NOTIFY=&SYSUID, 
//         MSGCLASS=X 
/*ROUTE XEQ BMCPLX1 
/*JOBPARM SYSAFF=DB2A 
//* 
//RECOVER EXEC PGM=AFRMAIN,REGION=0M, 
//             PARM='DEBA,EXAMPLE16,NEW/RESTART,MSGLEVEL(2)' 
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//          DD DISP=SHR,DSN=DB2.DSNEXIT
//          DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSIN     DD * 
 OPTIONS MAXKSORT 12 
 RECOVER TABLESPACE DBRDASTC.TSRDASTC 
 REBUILD INDEX (ALL) TABLESPACE DBRDASTC.TSRDASTC 
/* 
//

Related topic

Examples of BMC AMI Recover jobs

Example 16: Using MAXKSORT and recovering a table space

Comments