LargeStatementSupport
The LargeStatementSupport parameter specifies whether the High-speed Apply Engine can process SQL statements or logical log input records that are longer than 262,144 bytes (256 KB).
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [StartUp] |
Abbreviation | None |
DBMS | Db2, Db2 LUW, Oracle |
Required? | No |
Valid values | Yes, No |
Default value | No |
Usage
Specify one of the following values for the LargeStatementSupport parameter:
- No directs High-speed Apply Engine to issue error message BMCAPT0046 if either an SQL statement or a logical log record in the input file is longer than 256 KB bytes. No is the default value.
- Yes directs High-speed Apply Engine to extend the limit on an input statement of record to 1,048,576 bytes (1 MB).
If you are processing logical log input that includes data from large volume columns (such as XML or LOB columns), consider specifying Yes for this parameter to accommodate the larger amount of data. If processing in your environment requires that you process an SQL statement or a logical log record that is longer than 1 MB, contact BMC Customer Support for assistance.
Related topic