Skip to Content

Default language.

Information
Limited support BMC 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.

PARTS or LPARTS

Use these options to specify a list of partitions. PARTS indicates that the listed partitions are physical partitions. LPARTS indicates that the partitions are logical partitions. You cannot specify both PARTS and LPARTS.

BMC AMI Unload unloads all listed partitions. Partition lists consist of numbers that represent a single partition number separated by commas, or ranges that represent a range of numbers separated by a colon.

Information
Example

The specification 1,5,7:9,20:50 tells BMC AMI Unload to unload partitions 1, 5, 7, 8, and 9, and all partitions between 20 and 50.

If a partition list includes the same partition more than once, an error occurs.

Information
Example

The partition list 1,5,2:9 is invalid because partition 5 is specified twice, once explicitly and a second time as part of a range.

To include blanks in a partition list, enclose the entire list in parentheses.

Warning

Important

Do not use MODE(DB2SQL) or MODE(AUTO) with this option.

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams 


 

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

BMC AMI Unload for Db2 12.1