DB2 Version 9.7 for Linux, UNIX, and Windows

CLIPkg CLI/ODBC configuration keyword

Specifies the number of large packages to be generated.

db2cli.ini keyword syntax:: CLIPkg = 3 | 4 | ... | 30
Default setting:: Three large packages are generated.
Usage notes:

This keyword is used to increase the number of sections for SQL statements in CLI/ODBC applications. If it is used, the administrator should explicitly bind the required bind files with the CLIPkg bind option. For client applications, the db2cli.ini file on the client must be updated with this value of CLIPkg. For CLI/JDBC stored procedures, the db2cli.ini file on the server (DB2® Database for Linux, UNIX, and Windows) must be updated with the same value of CLIPkg.

If the value is NOT an integer between 3 and 30, the default will be used without error or warning.

This setting only applies to large packages (containing 384 sections). The number of small packages (containing 64 sections) is 3 and cannot be changed.

It is recommended that you only increase the number of sections enough to run your application as the packages take up space in the database.