Explanation
The LUW_STATEMENT_LIMIT MUF startup option specifies the maximum number x of SQL statements you want to be active at any given time for a single logical-unit-of-work (LUW). When a LUW reaches the limit specified with LUW_STATEMENT_LIMIT, subsequent attempts to prepare or execute additional statements beyond the limit are rejected with a -323 SQLCODE.
The SQLSTATE that equates to this SQL return code is 54S05.
User Response
Use the LUW_STATEMENT_LIMIT MUF startup option to increase the number of SQL statements allowed in the LUW, or use more frequent commits. If you are using the CA Datacom Server, see the documentation for that product that gives information about cursor behavior options on commits and rollbacks. For information about using the LUW_STATEMENT_LIMIT MUF startup option, see the CA Datacom/DB Database and System Administration Guide.
|
Copyright © 2014 CA.
All rights reserved.
|
|