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 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.

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='DGE,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)
/*
//

Related topics

Examples-of-BMC-AMI-Recover-jobs

DD statements for RECOVER BUILDINDEX jobs

 

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