We are working on a java application (using WSAD) using DB2 version 8 on Solaris.
I get a message
[IBM][CLI Driver][DB2/SUN] SQL0805N Package "NULLID.SYSLN......" was not found. SQLSTATE=51002
The action to be taken would seem quite straight forward - bind package.
However, it's not that simple for me because
this error was encountered while the java application was executing, and obviously the act that lead to the 805 error was behind the scenes (possibly done by SQLJ).
So my questions to you all are
-- What does [IBM][CLI Driver][DB2/SUN] tell you ? does it imply it's a SQLJ related message or a JDBC related error ? and related to a SQLJ setting ?
-- What does NULLID. tell you ? source of the package ?
-- how do I track down the source of the problem that leads to the 805 ?
it has always been a challenge to troubleshoot middleware errors.
First guess is that you have different fixpak levels between DB2 client (WAS Server) and DB2 server and need to rebind the client packages.
Use the db2cli.lst in SQLLIB/bnd for that.
> db2 connect to <your_db_name>
> db2 bind @db2cli.lst blocking all grant public
CLI driver is more or less the underlying client software.
for the sql code enter (works for any sqlcode):
> db2 ? sql0805
I dont want to print the output here, it is rather long, but it also states the following:
> If the DB2 utility programs need to be rebound to the database,
> the database administrator can accomplish this by issuing one of
> the following CLP command from the bnd subdirectory of the
> instance, while connected to the database:
> o "db2 bind @db2ubind.lst blocking all grant public" for the
> DB2 utilities.
> o "db2 bind @db2cli.lst blocking all grant public" for CLI.