Siebel Server Installation Guide for Microsoft Windows > Creating the DB2 Universal Database for Windows and UNIX > DB2 Database Configuration Guidelines >

Increasing the Number of ODBC Statement Handles

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, you should increase this number automatically each time you install the DB2 UDB client, or when rebinding database utilities.

It is recommended that you increase the number of CLI packages to six by rebinding the CLI packages, using the special DB2 CLIPKG bind option.

To rebind the CLI packages

  1. Navigate to the sqllib/bnd in the DB2 instance home directory using a method appropriate to your operating system.

    2. On most Windows machines, navigate to C:\sqllib\bnd from a DB2 Command window.

  2. Connect to the DB2 UDB database.
  3. Enter the following command:

    4. db2 bind @db2cli.lst blocking all grant public clipkg 6

For more information about the DB2 bind command and the CLIPKG option, see DB2 UDB Administration Guide.


 Siebel Server Installation Guide for Microsoft Windows 
 Published: 25 June 2003