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
Example
MAXTRANSMEM 5000000