Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: db2 sql eror: SQLCODE: -805, SQLSTATE: 51002

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Re: db2 sql eror: SQLCODE: -805, SQLSTATE: 51002

    Originally posted by alda
    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
    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

  4. #4
    Join Date
    Oct 2003
    Posts
    3
    Originally posted by Marcus_A
    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).

    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

  5. #5
    Join Date
    Oct 2003
    Posts
    3

    Re: db2 sql eror: SQLCODE: -805, SQLSTATE: 51002

    Originally posted by M_RAS
    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?
    Thanks,
    Alda

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Regardless of whether they come pre-installed, if you can rebind the packages, I would do so.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •