Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Recover for Db2 13.1.

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

 

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