Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

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 Unload for Db2 13.1.

PART or LOGICAL PART


The PART option specifies the partition numbers of a partitioned table space to unload.

GUID-AA71A731-66E5-4AE2-A622-254B54D70FEB-low.png

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, BMC AMI Unload 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, BMC AMI Unload ignores any occurrence after the first.
  • You can specify integer values from 1 through 4096.
Example
PART 10,1:5,7

 This example illustrates a valid PART specification for partitions 1 through 5, 7, and 10.

Considerations

The following considerations apply to the PART option:

  • You cannot specify multiple partitions when unloading from an image copy.
  • When you are unloading XML data, the PART option applies only to the base table space.
  • 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.

 

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