Default language.

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

+SORT

+SORT enables you to tell 

BMC AMI Load

 whether to sort data in clustering index order.

If you know that the data has already been sorted, specify NO to prevent the sort. Specify YES when your data is not in order and you want a LOAD REPLACE to result in a clustered table space that does not need to be reorganized.

NGT_Load_SORT.png

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

NO

(default) NO tells BMC AMI Load not to sort the input data before loading.

The ORDER-YES option overrides +SORT(NO).

YES

YES tells BMC AMI Load to sort the input data in clustering index order before loading.


Example
+SORT(NO)

BMC AMI Load does not sort the input data in clustering index order before loading.


Related topic

BMC-AMI-Load-parameters-LODPARMS-DD


 

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