+COMMIT

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

Related topics

BMC-AMI-Load-parameters-LODPARMS-DD

APCOMMIT

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.

 

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