1. Installation Guide
  2. Guidelines for Preventing IBM DB2 from Running Out of ODBC Statement Handles

Guidelines for Preventing IBM DB2 from Running Out of ODBC Statement Handles

This topic is part of Configuring an IBM DB2 Database for Siebel CRM.

IBM DB2 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 use, increase this number automatically each time that you install the DB2 Client, or when you rebind database utilities. You can increase the number of CLI packages with the CLIPKG option for the bind command.

To rebind the CLI packages

  1. (Windows) Navigate to sqllib\bnd (C:\sqllib\bnd from a DB2 Command Window) in the IBM DB2 instance home directory, by using a method appropriate to your operating system.

  2. (UNIX) Navigate to sqllib/bnd in the IBM DB2 instance home directory, by using a method appropriate to your operating system.

  3. Connect to the DB2 database, and enter a command similar to the following example, which sets the number of CLI packages to 30:

    db2 bind @db2cli.lst blocking all grant public clipkg 30

    Specify a value for CLIPKG that is sufficient to run your applications. For more information about the DB2 bind command and the CLIPKG option, see IBM DB2 documentation.