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.

NOWORKDDN strategy

In a conventional REBUILD INDEX strategy that uses WORKDDN, the keys to build the index are written to a work data set (typically SYSUT1) while they are being extracted from the table space data.

When the extraction is complete, the keys are read back in and sorted, and then the index is built from the sorted key/RID pairs.

However, using the NOWORKDDN option allows the extracted keys to go directly into a sort process. This strategy avoids writing and rereading the key work data set, and no work data set is required to hold the extracted keys. While restartability may be affected (see the table in, Restarting an NGT Recover job), the I/O reduction significantly reduces the time that is required to rebuild the index.

If you do not specify WORKDDN, the NOWORKDDN option is the default. NOWORKDDN is required for the rebuild of the partitioning index when used together with the RECOVER UNLOADKEYS strategy for the nonpartitioning indexes.

For more information, see NOWORKDDN.

Related topic


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

Comments