Commit during Fragmentation batch processing

IN_FRAG_BAT_COMMIT:

Used to control commit behavior when inserting batches as part of fragment processing.

Since fragmentation allows parallel processing of related fragments, two threads can have an interest in the same batch.

If the batch insert is not committed, one or more threads can be held up waiting for the 'inserting' thread to complete.

Valid values are Y | X | N | <unset>
  • Y = commit the inserts immediately (non-XA system).
  • X = commit the inserts immediately (XA system).
  • N = don't commit until end of the unit of work.
  • <unset> = defaults to Y.
  • invalid values are treated as N.