PART or LOGICAL PART

This option is valid only when DIRECT YES is in effect.

You can specify one, some, or all of the partitions either individually or by specifying a range. If you do not specify PART, UNLOAD PLUS unloads all partitions of the table space.

Optionally, you can specify the LOGICAL keyword with PART to indicate that you are specifying the logical partitions to unload rather than the physical partitions.

Specifying partition numbers

Note the following information about how to specify partition numbers with the PART option:

• Individual partitions in a list can be in any order (but partitions within a range must be in ascending order).
• You can specify a mixture of individual partitions and ranges of partitions.
• If you specify a partition number more than once, UNLOAD PLUS ignores any occurrence after the first.
• You can specify integer values from 1 through 4096.

The following example illustrates a valid PART specification for partitions 1 through 5, 7, and 10:

Restrictions

The following restrictions apply to the PART option:

• UNLOAD PLUS terminates if you specify both logical and physical partitions in the same job.
• If you specify INFILE ddname and supply DDL (using a DDLIN data set), UNLOAD PLUS ignores the LOGICAL keyword and considers the specified partitions to be physical partitions.

Additional considerations

The following considerations apply to the PART option:

• When you are unloading XML data, the PART option applies only to the base table space.
• When you are unloading from multiple table spaces, the PART option applies to all table spaces.
• Specifying PART within a SELECT OPTIONS statement overrides the PART command option for that SELECT statement.
• Unloading objects with a large number of partitions increases the potential for encountering such issues as performance problems and memory restrictions. For recommendations, see Tuning when unloading objects with a large number of partitions.