SQL0805N Package “” was not found.

You may also like...

3 Responses

  1. January 5, 2012

    […] I mentioned earlier, what I want, or what I am trying to accomplish.. This is what I found based on my research so far: By default DB2 creates 3 packages when you do the cli binds, these three packages together provides the capability of a total of 1344 open cursors. In my case due to some funky application code, the 1344 open cursor limit is exhausted and I was looking to find ways to increase them… ( this is what I was trying to accomplish) The quick fix is to increase the number of packages and thereby increase the total limit on the number of open cursors.. The packages have a limit, you cannot take that higher than 30 which represents 11712 concurrently open cursors… The real fix is to come from the application folks.. Do they really need so many open cursors? A code fix is in order: Check this out: This decoded the problem I faced.. SQL0805N Package “” was not found. […]

  2. September 4, 2013

    […] my blog entry on this issue for more information and a link to a IBM tech note on the […]

  3. March 14, 2015

    […] entry by DB2 DBA Ember Crooks is stellar with regards to binding and what it means. She also wrote a previous entry on packages not being found and when to up the CLIPKG number for the binds and what that means. These articles […]

Leave a Reply

Your email address will not be published. Required fields are marked *