IBM Support

SQL0805N during BIND command for collection id other than NULLID

Troubleshooting


Problem

Bind command with GRANT, for collection id other than NULLID, may return SQL0805N, if NULLID packages for db2ajgrt.bnd file are not present

Symptom

You may get error like below:

C:\Program Files\IBM\SQLLIB_01\bnd>db2 BIND @db2cli.lst COLLECTION test BLOCKING ALL GRANT PUBLIC SQLERROR continue

LINE MESSAGES FOR db2cli.lst
------ ---------------------------------------------- -----------------
-----
SQL0061W The binder is in progress.

LINE MESSAGES FOR db2clipk.bnd
------ ---------------------------------------------- -----------------
-----
SQL0805N Package "NULLID.SQLABK02 0X4141414141454358" was
not found. SQLSTATE=51002

LINE MESSAGES FOR db2clist.bnd
------ ---------------------------------------------- -----------------
-----
305 SQL0104N An unexpected token ":H00025" was found following
"LT TRANSFORM GROUP =". Expected tokens may include:
"<transf_grp_ref>". SQLSTATE=42601
308 SQL0104N An unexpected token "DIAGNOSTICS" was found
following "GET ". Expected tokens may include: "JOIN
<joined_table>". SQLSTATE=42601
311 SQL0104N An unexpected token "DIAGNOSTICS" was found
following "GET ". Expected tokens may include: "JOIN
<joined_table>". SQLSTATE=42601

LINE MESSAGES FOR db2cli.lst
------ ---------------------------------------------- -----------------
-----
SQL0091N Binding was ended with "1" errors and "3" warnings.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - Bind","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

swg21670974

Page Feedback