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.

NOWORKDDN


The NOWORKDDN option causes the extracted keys to be sent directly to the sort routine without first writing these keys to a work data set. Using this option causes the index to rebuild faster. However, restartability is more limited because, without the work data set, restarting at the beginning of the BUILD phase is not possible. The restart will have to redo the UNLOAD phase.

The keys are sent directly to the sort if neither WORKDDN nor NOWORKDDN is specified, and no SYSUT1 DD statement exists in the JCL.

If you use RECOVER UNLOADKEYS for the space, NOWORKDDN is the default for a partitioned index.



 

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