Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / October 2007

Tip: Looking for answers? Try searching our database.

Package "NULLID.SYSLN31E 0X5359534C564C3031" was not found

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kavin - 29 Oct 2007 05:55 GMT
we r getting Package "NULLID.SYSLN31E 0X5359534C564C3031" was not
found error in our production server..

when v check with  "select * from syscat.packages".. that package
SYSLN31E is not listed there..

if v restart the DB, for 2 days it is working fine, then again it is
giving the same error..

is it a problem of web portal server?

is there any solution for this?
Mark A - 29 Oct 2007 08:04 GMT
> we r getting Package "NULLID.SYSLN31E 0X5359534C564C3031" was not
> found error in our production server..
[quoted text clipped - 8 lines]
>
> is there any solution for this?

You are getting a -805 I assume.

In this case it means that no more large cursors are available for the
package. The default is 3 large cursors (SYSLN300, SYSLN301, and SYSLN302)
but since it cannot find (-805) cursor 31 (1E is 30 and the first package is
SYSLN300) then that means some has already rebound that package with the
maximum number of large cursors that can be defined (30).

If this is a production server, the cause of this is sloppy programming. Too
many cursors are open at one time. Since most programmers rely on java or
some java tool to create their SQL, that means they are not closing their
transactions and/or not committing frequently enough. The DB2 Application
Development Guide has examples of how to close a transaction in java.

Send it back to the programmers and tell them they need to learn how to
write programs properly.

If this is happening on a development server where you are using RAD, etc in
debug mode (which may not close transactions in debug mode) ask the
programmers to reboot their workstations at least daily and to shut down RAD
when they are not using it.
Roger - 29 Oct 2007 14:27 GMT
> we r getting Package "NULLID.SYSLN31E 0X5359534C564C3031" was not
> found error in our production server..
[quoted text clipped - 8 lines]
>
> is there any solution for this?

I had a smiliar situation.  This means the app is not closing the
dynamic sql cursors properly. Its either left at a hanging state and
not released or not closed proplerly. Its an application problem.
DB2PD can help you identify how many cursors are open at the time of
error.  If its a prod app and its erroring out with -805 increase the
CLIPKG to a higher number. This is a band aid to the problem to get
you out of the problem. You can also db2 a DB2JDBCBIND to increase the
number of cursor handles too.
Basically the above two temporarily solutions are to get you out of
the problem for time being, but the application dev. needs to fix the
code.

HTH

Roger
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.