Limiting the Number of Statements

Set the MAX_STATEMENT_COUNT option to limit the number of prepared statements for a connection can make.

The MAX_STATEMENT_COUNT option limits the maximum number of prepared statements that a connection can use at once. If a server needs to support more than the default number (50) of prepared statements at any one time for any one connection, then you can set the MAX_STATEMENT_COUNT option to a higher value

Related concepts
Restricting Concurrent Queries
Setting the Number of CPUs Available
Limiting Temporary dbspace Use By a Query
Limiting Queries by Rows Returned
Forcing Cursors to be Non-Scrolling
Limiting the Number of Cursors
Prefetching Cache Pages
Optimizing for Typical Usage
Controlling the Number of Prefetched Rows