Hello,
I'm using DB2 V8.1 and JDBC type 4.
My application runs OK for a couple of days and then the following errors occurs:
com.ibm.db2.jcc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031
Error code: -805 SQL state: 51002

Does anybody have an idea how to solve this problem?
Thank you,
Alda

What does the Messages and Codes manual say? There is a link to DB2 manuals in the "Useful DB2 Stuff" thread. The PDF manuals can be text-searched with the appropriate version of Acrobat (free).

1- bind you application again. if it does not work
2- if you are using Webspher MQ, please use proper MQ identification. if it does not work
3- complie you application (whit new .bnd file) and bind again.

Thanks

There is a similar thread from March 2003, Subject:
com.ibm.db2.jc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031
(http://dbforums.com/arch/39/2003/3/716221)
But the answer for the problem is not there.
I'm using Linux and according to one of the posts I don't need to run DB2Binder utility because the packages are pre-installed.
So now the question is: what does this package does and how do I get it?
Alda


Following what DB2 manual says:

SQL0805N Package package-name was not found.
Explanation: The statement cannot complete because the necessary package was not
found in the catalog.

The package-name is either in the form:
. 'pkgschema.pkgname 0Xcontoken', where the consistency token is given in
hexadecimal.
. 'pkgschema.pkgname.pkgversion', if the package version is the empty string
'.pkgversion' is omitted from the name.

Possible causes for this message (SQLCODE) are:
. The package was not bound or it was dropped.
. If attempting to run a DB2 utility or CLI application, the DB2 utilities may
need to be rebound to the database.

Note that when version-ids are in use for the given package-schema.package-name,
there may be packages defined with the same package schema and package name,
but the correct package is not found since the existing packages do not match
the requested version or consistency token. A package must match all three parts
of the package-name. When multiple versions are being used, additional causes
for this messages are:

. the version of the application being executed was precompiled, compiled, and
linked, but was not bound, or it was bound but that version of package was
subsequently dropped.
. the application was precompiled and bound, but not compiled and/or linked, so
the application being executed is not up to date.
. the package was bound from a bind file generated by a different precompile of
the source file than the precompile that produced the modified source file
that was compiled and linked into the application executable.
. a new application was bound with the same name (and version) of an existing
package, thus replacing the existing package. If the application associated
with the replaced Federated Systems Guide for more information about binding
packages to data sources.

sqlcode: -805
sqlstate: 51002

There is a similar thread from March 2003, Subject:
com.ibm.db2.jc.b.SQLException: NULLID.SYSSH203 0X5359534C564C3031
(http://dbforums.com/arch/39/2003/3/716221)
But the answer for the problem is not there.
I'm using Linux and according to one of the posts I don't need to run DB2Binder utility because the packages are pre-installed.
So now the question is: what does this package does and how do I get it?
Thanks,
Alda

Regardless of whether they come pre-installed, if you can rebind the packages, I would do so.