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.

+COMMIT

+COMMIT specifies the number of records to insert before performing a commit during a LOAD RESUME YES SHRLEVEL CHANGE job.

NGT_Load_COMMIT.png

The APCOMMIT syntax option overrides this parameter. For more information, see APCOMMIT.

Important

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

-1

(default) This value tells BMC AMI Load to perform a commit after all rows have been inserted.

integer

Specify an integer to tell BMC AMI Load the maximum number of rows to insert before performing a commit.

Example
+COMMIT(10)

BMC AMI Load performs a commit after it inserts every tenth row.

Related topics

BMC-AMI-Load-parameters-LODPARMS-DD

APCOMMIT

 

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