Skip to Content

Default language.

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

UNLDDN

UNLDDN allows you to override the default ddname (SYSREC) or ddname prefix for the output data set that contains the unloaded rows to be reorganized.

Related topic

Basic REORG PLUS processing options

 

UNLDDN.png

This option applies to a table space reorganization only.

For information about specifying and using the SYSREC data set, see  SYSREC data sets.

If you use this command option to override the default name in the installation options module, you must also change the ddname in your JCL.

DSNUTILB reorganization jobs

When invoking DSNUTILB, REORG PLUS uses this option only to pass a value for the &DDNAME variable for the data set name pattern. REORG PLUS includes this information in the TEMPLATE control statement that it builds for the IBM Db2 REORG utility.

Multiple data sets

If you use multiple unload data sets, the ddname that you specify in this option becomes a prefix. The ddname that you specify in the JCL must have the partition number nn appended to this prefix. The length of nn can be from one through seven characters, depending on the length of the ddname prefix. The maximum length of the ddname with the prefix must be eight bytes or less. For example, if you have 103 unload data sets, you can specify the ddname here as SYSRC, and specify SYSRC103 in your JCL.

Dynamic data set allocation

If dynamic data set allocation is active and you specify more than one ddname prefix for dynamic allocation, the prefix for each ddname must be different enough for REORG PLUS to differentiate one prefix from another. To be different enough, if these prefixes are different only because one prefix has additional trailing bytes, then these trailing bytes must contain at least one non-numeric byte. For example, the first set of prefixes that follow is sufficiently different, but the second set is not:

  • Acceptable set:

    BMCRD
    BMCRDWK

  • Not acceptable set:

    BMCRD
    BMCRD11

When you dynamically allocate SYSREC data sets, REORG PLUS appends the data set number to the ddname prefix that you specify. To dynamically allocate more than 99 SYSREC data sets, use this option to specify a ddname prefix. The prefix plus the highest data set number must not exceed eight characters.

Specifying the default

You can specify the default for the UNLDDN command option in your installation options module by using the UNLDDN installation option. REORG PLUS was shipped with a default value of SYSREC for this option. The command option overrides the default that is in the installation options module.

 

 

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

REORG PLUS for DB2 13.1