Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Unanswered: SQL0094N Binding error

    Hi,
    We have a db with a user other than administrator. Using this user we are connecting to a C++ application. Now the application throws the following error:

    SQL0094N Binding was ended because of a user interrupt request. SQLSTATE=57014

    SQL0805 Package "NULLID.SQLL6D04" was not found. SQLSTATE=51002

    The same db server has another db with another user in it. We are able to connect using this db but not the earlier one.

    Please help, if anyone has come accross such error. The help in DB2 is not satisfying the requirements for a solution.
    Prashant

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: SQL0094N Binding error

    Where do you get these errors ? Client or Server box? Are the versions/fixpacks/OS different between client and server ?

    On the client, issue

    db2 bind @db2cli.lst grant public
    db2 bind @db2ubind.lst grant public

    after connecting to the database as a user with privilege to bind the packages.


    HTH

    Cheers

    Sathyaram
    Originally posted by dahalkar_p
    Hi,
    We have a db with a user other than administrator. Using this user we are connecting to a C++ application. Now the application throws the following error:

    SQL0094N Binding was ended because of a user interrupt request. SQLSTATE=57014

    SQL0805 Package "NULLID.SQLL6D04" was not found. SQLSTATE=51002

    The same db server has another db with another user in it. We are able to connect using this db but not the earlier one.

    Please help, if anyone has come accross such error. The help in DB2 is not satisfying the requirements for a solution.

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: SQL0094N Binding error

    did you try and run the rebind against the package
    db2 rebind nullid.packagename, you could also select against systcat.packages and make sure that package name exits. You might need to re-create the package.

Posting Permissions

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