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.

Related topic

Examples-of-BMC-AMI-Recover-jobs


//AFREX16  JOB (PAFR),'EXAMPLE 16',
//         CLASS=Q,NOTIFY=&SYSUID,
//         MSGCLASS=X
/*ROUTE XEQ BMCPLX1
/*JOBPARM SYSAFF=DB2A
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,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
/*
//

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*