Example 7: Building a nonpartitioned index

Example 7 uses the keys that were unloaded and sorted in Example 6 to build an index.

See Example-6-Extracting-nonpartitioned-index-keys.

Related topics

Examples-of-BMC-AMI-Recover-jobs

DD statements for RECOVER BUILDINDEX jobs

JCL building an index with sorted unloaded keys

//AFREX07 JOB (0000),'EXAMPLE 7',
//        CLASS=Q,NOTIFY=&SYSUID
//        MSGCLASS=X
//*
//RECOVER EXEC PGM=AFRMAIN,REGION=0M,
//             PARM='DEJM,EXAMPLE07,NEW/RESTART,MSGLEVEL(2)'
//STEPLIB  DD DISP=SHR,DSN=product.libraries
//          DD DISP=SHR,DSN=DB2.DSNEXIT
//          DD DISP=SHR,DSN=DB2.DSNLOAD
//SKEY1     DD DISP=SHR,DSN=RDASTC.BMCDBJ.PARTS12.SUNKEY1
//SKEY2     DD DISP=SHR,DSN=RDASTC.BMCDBJ.PARTS34.SUNKEY2
//SKEY3     DD DISP=SHR,DSN=RDASTC.BMCDBJ.PARTS56.SUNKEY3
//SYSIN     DD *
  RECOVER BUILDINDEX (RDASTC.BMCIXJ2)
/*
//

 

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