CLI bind files and package names
CLI packages are automatically bound to databases when the databases are created or upgraded, or a fix pack is applied to either the client or the server. If a user has intentionally dropped a package, then you must rebind db2cli.lst.
- Linux® and UNIX
-
db2 bind BNDPATH/@db2cli.lst blocking all grant public
- Windows
-
db2 bind "%DB2PATH%\bnd\@db2cli.lst" blocking all grant public
- db2clipk.bnd
- db2clist.bnd
Warnings that are generated when binding CLI packages (such as db2clist.bnd or db2cli.lst) to workstation or host servers are expected. This is because Db2® database systems use generic bind files, but the bind file packages for CLI packages contain sections that apply to specific platforms. Therefore, a Db2 database system might generate warnings during the binding against a server, when it encounters a platform-specific section that does not apply to the server.
LINE MESSAGES FOR db2clist.bnd
------ --------------------------------------------------------------------
235 SQL0440N No authorized routine named "POSSTR" of type
"FUNCTION" having compatible arguments was found.
SQLSTATE=42884
Bind file name | Package name | Needed by Db2 servers on Linux, UNIX, and Windows | Needed by host servers | Description |
---|---|---|---|---|
db2clipk.bnd | SYSSHxyy | Yes | Yes | dynamic placeholders - small package WITH HOLD |
SYSSNxyy | Yes | Yes | dynamic placeholders - small Package NOT WITH HOLD | |
SYSLHxyy | Yes | Yes | dynamic placeholders - large package WITH HOLD | |
SYSLNxyy | Yes | Yes | dynamic placeholders - large package NOT WITH HOLD | |
db2clist.bnd | SYSSTAT | Yes | Yes | common static CLI functions |
db2schema.bnd | SQLL9vyy | Yes | No | catalog function support |
Note:
For example, for the dynamic packages:
Previous versions of Db2 servers do not need all of the bind files and will therefore return errors at bind time. Use the bind option SQLERROR CONTINUE so that the same package can be bound on all platforms and errors will be ignored for any statements not supported there. |
db2schema.bnd bind file
The db2schema.bnd bind file is automatically bound when the database is created or upgraded, or a fix pack is applied on Db2 servers on Linux, UNIX, and Windows, and exists only on these types of servers. This bind file is located at the server and should be bound manually (from the server), if the package was intentionally dropped by a user or if an SQL1088W (+1088) warning is received after database creation or upgrade.
Only the most recent version of this package is needed.
bind db2schema.bnd blocking all grant public
If an SQL1088W warning was received after database creation or upgrade, and the db2schema.bnd package is missing, increase the applheapsz database configuration parameter to 128 or greater, and attempt to rebind. No errors should be reported during binding.