Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS > Configuring an IBM DB2 UDB Database for Siebel Applications >
Guidelines for Preventing DB2 UDB from Running Out of ODBC Statement Handles
This topic is part of Configuring an IBM DB2 UDB Database for Siebel Applications.
IBM DB2 UDB can quickly run out of ODBC statement handles, depending on the number of business objects your enterprise uses. Because it is difficult to know how many business objects your users actually use, increase this number automatically each time you install the DB2 UDB client, or when rebinding database utilities.
Increase the number of CLI packages to 6 by rebinding the CLI packages, using the special DB2
CLIPKG bind option.
To rebind the CLI packages
- Navigate to sqllib/bnd (C:\sqllib\bnd from a DB2 Command window) in the DB2 instance home directory, using a method appropriate to your operating system.
- Connect to the DB2 UDB database, and enter the following command:
db2 bind @db2cli.lst blocking all grant public clipkg 30
For more information about the DB2 bind command and the
CLIPKG option, see IBM documentation such as the DB2 UDB Administration Guide.