CLIPkg CLI/ODBC and IBM data server driver configuration keyword

db2cli.ini keyword syntax:

CLIPkg = 3 | 4 | ... | 30

IBM® data server driver configuration file (db2dsdriver.cfg) syntax:

<parameter name="CLIPkg" value="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® Version 6.1 or later on UNIX or Intel platforms) 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.