Troubleshooting
Problem
If you bind the Db2 utility packages (db2ubind.lst) against down level databases, the bind command might return SQL0020W as following.
SQL0020W The bind or precompile command parameters or parameter values
in the following list were ignored because they are not supported
by the target database: "RESERVEDNAME".
Cause
The new bind option RESERVEDNAME is introduced in Db2 11.5.5. This option is used to check conflicting in the packages in the NULLID schema.
The option is specified in the Db2 utility packages. For example:
$ db2bfd -b db2clpcs.bnd
db2clpcs.bnd: Header Contents
Header Fields:
Field Value
----- -----
releaseNum 0x800
Endian 0x4c
numHvars 286
maxSect 340
numStmt 798
optInternalCnt 4
optCount 11
Name Value
------------------ -----
Isolation Level Cursor Stability
Creator "NULLID "
App Name "SQLC2P31"
Timestamp "AAAAAGFk:2020/05/06 00:00:00:00"
Cnulreqd Yes
Sql Error No package
Block Block All
RESERVEDNAME YES
Validate Bind
Date Default/local
Time Default/local
You can see RESERVEDNAME YES in the package options.
Resolving The Problem
If you bind the packages in Db2 11.5.5 or later against Db2 11.5.4 or earlier, the warning is expected, and can be ignored.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmRAAU","label":"Programming Interface-\u003EBind and Packages"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0"}]
Was this topic helpful?
Document Information
Modified date:
09 December 2022
UID
ibm16846789