Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2010
    Posts
    335

    Unanswered: Packages missing

    Hi,

    i know, there have been a lot of discussions on Packages, espacially for SYSLH.

    An Application is throwing the Messages
    SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH22F
    SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH229

    There Reason is obvious: The Packages don't exist.
    I'm just wondering, because i bound the Packages SYSLH200 - SYSLH204, so i'ld expect a missing SSLH205 and not 229 or 22F.
    Anyone has a clue about it?

    Edith said, that i forgot the Environment:
    DB2 10.1.2 on SLES 11 SP2

    Wasn't there a limit of 30 Packages?
    Last edited by nvk@vhv; 11-13-13 at 05:17. Reason: Forgot DB2 Version

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Adding more packages is like giving drugs to a drug addict and hoping that solves the problem. Someone needs to make sure java programmers are closing transactions properly, and that commits are being issued appropriately.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2010
    Posts
    335
    Hi Marcus,

    thanks for your Answer. I'm not planing to add more Packages.
    As said i've the Packages
    SYSLH200
    SYSLH201
    SYSLH202
    SYSLH203
    SYSLH204

    So i expected an Error like SYSLH205 is missing, but i got SSYSLH229 and SYSLH22F missing. What's happening there?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I would need to see the entire exact error message. There are several different cursor packages that may be involved.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by nvk@vhv View Post
    Wasn't there a limit of 30 Packages?
    DB2Binder can create more.

  6. #6
    Join Date
    Jan 2010
    Posts
    335
    Had some other Issue with the Application. Rolled Back to the old Version meanwhile.
    So Topic is "solved" for now.

    Thanks for help.

Posting Permissions

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