Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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

Was this page helpful? Yes No Submitting... Thank you

Comments