Logical Transaction Size
Logical Transaction Size is a functionality used to indicate the maximum number of records to commit in one batch for database tables updated by the job. Increasing the logical transaction size will create bigger batches that get committed to the database at one time. Changing this setting could potentially have an impact on job performance when updating large amounts of data.
Changing the logical transaction size
- Access the Job Definition utility (jobdef).
- On the Job Definition form, add a new step.
- Press Define (F6) and select D: Logical Transaction Size.
- Specify the number of transactions to be committed to the database. The default value is 50.
- Press Enter to save your changes.