About Connection Pooling and Cursor Close

Connection Pooling can give you flexibility in increasing the number of rows returned from a query or in keeping cursors open by setting the DSMaxCursorSize parameter to -1. However, consider the latter option only if it is essential to your business needs. Setting the DSMaxCursorSize parameter to the -1 setting requires careful DB2 buffer pool tuning and the use of DB2 storage contraction DSNZPARMs. For further information, see About Cursor Close and DSNZPARM Parameter Settings for Siebel CRM.

You must also review the unlimited cursor close values in combination with other factors, such as:

• DB2 DBM1 virtual storage

• Transaction rate of arrival

• Average length of a transaction

• Maximum number of connected threads

• Number of expected long-running complex queries