SQL error 805

[db2group88]

we had this error while running the applicaiton on db2 v8.2 EE on
windows, jcc driver is what we use

SQL error 805

com.ibm.db2.jcc.b.SQLException: NULLID.SYSLH203 0X5359534C564C3031,
based on my experience, there is no such package exist, so what would
be the main resaon behind this? thank you

[db2group88]

More info,

the query inside the loop are just simple select and insert statement
with java class.

[Mark A]

db2group88 wrote:

More info,

the query inside the loop are just simple select and insert statement
with java class.

This question has been answered many times. Try Google Groups archive
and search on 'NULLID.SYSLH203'

[db2group88]

the MAXAPPLS is 500 and APPLHEAPSZ is 12000, i have make sure statement
close properly. what else?

[db2group88]

More info, i have done this java -cp "D:\program
files\ibm\sqllib\java\db2jcc.jar" com.ibm.db2.jcc.DB2Binder -url
jdbc:db2://test -size 80 and this db2 bind @db2cli.lst blocking all
grant public sqlerror continue CLIPKG 5

[Mark A]

db2group88 wrote:

the MAXAPPLS is 500 and APPLHEAPSZ is 12000, i have make sure statement
close properly. what else?

What exactly does "close properly" mean? Do you do an explicit commit?

[Gregor Kova�]

db2group88 wrote:

we had this error while running the applicaiton on db2 v8.2 EE on
windows, jcc driver is what we use

SQL error 805

com.ibm.db2.jcc.b.SQLException: NULLID.SYSLH203 0X5359534C564C3031,
based on my experience, there is no such package exist, so what would
be the main resaon behind this? thank you

Hi!

When I get this I do:
db2jdbcbind.exe -url jdbc:db2://SERVER:50000/DATABASE_NAME -user
DATABASE_USER -password DATABASE_PASSWORD -size 300

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

[Knut Stolze]

db2group88 wrote:

we had this error while running the applicaiton on db2 v8.2 EE on
windows, jcc driver is what we use

SQL error 805

com.ibm.db2.jcc.b.SQLException: NULLID.SYSLH203 0X5359534C564C3031,
based on my experience, there is no such package exist, so what would
be the main resaon behind this? thank you

The main reason is that you do _not_ properly close your statement handles
in your application. Each statement handle is associated with a package,
and since you don't close them, you run out of packages eventually. You
can delay the problem by creating more CLI packages - maybe the delay is
sufficient that you won't hit the problem anymore - but that's not a fix.

A good description on CLI packages can be found here:
http://www.ibm.com/developerworks/db...hun/index.html

--
Knut Stolze
DB2 Information Integration Development
IBM Germany