WORKDDN DDName

The WORKDDN DDName option specifies the work data set ddname.

The default is SYSUT1 but might change to UNLOADnn for table spaces with fewer than 100 partitions when REBUILD INDEX is accompanied by one or more RECOVER UNLOADKEYS statements. For table spaces with 100 or more partitions, the default value is UNLOAnnn. WORKDDN is required when REBUILD INDEX is accompanied by RECOVERUNLOADKEYS for the same partition and NOUKSORT is specified.

Related topics

REBUILD-INDEX-option-descriptions

MAXKSORT-integer

When you use multiple REBUILD INDEX command statements, the following restrictions apply to the use of WORKDDN:

  • If you use multiple command statements for a nonpartitioned table space, the DDName that you specify for WORKDDN must be the same in all of the statements.
  • If you use multiple command statements for a partitioned table space and request the rebuilding of a nonpartitioned index, the DDName that you specify for WORKDDN must be the same in all of the statements. Otherwise, BMC AMI Recover cannot extract keys for all indexes from each partition in one pass of the table space.

If you specify only the rebuilding of a partitioned index for a partitioned table space with multiple REBUILD INDEX command statements, the value specified for WORKDDN has no restrictions.

WORKDDN can not be specified for a partitioned index if you use RECOVER UNLOADKEYS for the space.

Important

BMC AMI Recover ignores WORKDDN if the value of the MAXKSORT option is greater than 1. The value of MAXKSORT is set in the installation options or on the OPTION command. For more information about MAXKSORT, see MAXKSORT-integer and MAXKSORT.

If you specify RECOVERUNLOADKEYS and NOUKSORT together with REBUILD INDEX for the same table space and partitions, the WORKDDN ddname on both statements must be the same. The ddname is considered a prefix and must not be more than six characters for spaces with fewer than 100 partitions or not more than five characters for spaces with 100 or more partitions.

For more information, see Restrictions for key work data sets, SKEYDDN, SORTNUM, and SORTDEVT.

 

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