2.154 MAXTRANSMEM

Valid for

Extract

Description

Use MAXTRANSMEM to control the maximum amount of memory allocated for a transaction. If a transaction exceeds the maximum memory value, Extract only tracks the checkpoint of the begin transaction until the commit transaction is found. Once a commit is found, Extract returns and extracts data starting from the begin checkpoint. Do not set MAXTRANSMEM to an arbitrarily high number, since doing so leads to excessive memory consumption.

Default

5000000

Syntax

MAXTRANSMEM megabytes

megabytes

The number of megabytes. The minimum value is 2000000; the maximum value is 100000000.

Example

MAXTRANSMEM 5000000