By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,474 Members | 3,139 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,474 IT Pros & Developers. It's quick & easy.

getting -805 for SYSLH203

P: n/a
I have a DB2 UDB V8.2 (FP10) running on AIX. I have 3 application
server (AIX) connecting to the DB2 Server using JDBC. I have the
catalog the database as remote databases on the application server.
After running the application for a while, I got -805 on
NULLID.SYSLH203. I issued a bind on db2cli.lst with CLIPKG 5 . Then
after 1 hr, i got it for SYSLH205, so I bound it with CLIPKG 10
It hasn't appeared for the last 2 hrs. My question is should I change
db2cli.ini file with CLIPKG option. If yes, should each of them be with
CLIPKG=10 or should it be CLIPKG=3 each.

any input is appreciated..

Thanks

Roger

Jul 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If the packages are bound to the database then u don't need to change
in db2cli.ini.
In the database you can go all the way upto CLIPKG 30 and then u can do
a db2jdbcbind for more packages.

But the real issue here is there is a STATEMENT HANDLE LEAK in the
code.
Investigate from the CODE point of view also.

cheers...
Shashi Mannepalli
Roger wrote:
I have a DB2 UDB V8.2 (FP10) running on AIX. I have 3 application
server (AIX) connecting to the DB2 Server using JDBC. I have the
catalog the database as remote databases on the application server.
After running the application for a while, I got -805 on
NULLID.SYSLH203. I issued a bind on db2cli.lst with CLIPKG 5 . Then
after 1 hr, i got it for SYSLH205, so I bound it with CLIPKG 10
It hasn't appeared for the last 2 hrs. My question is should I change
db2cli.ini file with CLIPKG option. If yes, should each of them be with
CLIPKG=10 or should it be CLIPKG=3 each.

any input is appreciated..

Thanks

Roger
Jul 11 '06 #2

P: n/a
Hi there...the problem is still not solved.
Environement : DB2 V8.2 FP 10 application server is Vignette
application running on WAS 6.0

I have gone all the way up to CLIPKG 30 . Its still runnin gout of
SYSLH package.
Here are my questions :

1. How can i find out what is holding all these SYSLH pacakges ? When
I took a snapshot I see only cursors with SYSLH200 and SYSLH202. Yet
when I did a db2pd -static -db <dbnameI see lot of SYSLH20* packages.

2. What makes DB2 use SYSLH packages as supposed to SYSSH packages ?

3. How can I find where the STATEMENT HANDLE LEAK is ?

I am not able to replicate the error on test server. The app does not
use packages beyond LH203.

any input is greatly appreciated

Thanks
Shashi Mannepalli wrote:
If the packages are bound to the database then u don't need to change
in db2cli.ini.
In the database you can go all the way upto CLIPKG 30 and then u can do
a db2jdbcbind for more packages.

But the real issue here is there is a STATEMENT HANDLE LEAK in the
code.
Investigate from the CODE point of view also.

cheers...
Shashi Mannepalli
Roger wrote:
I have a DB2 UDB V8.2 (FP10) running on AIX. I have 3 application
server (AIX) connecting to the DB2 Server using JDBC. I have the
catalog the database as remote databases on the application server.
After running the application for a while, I got -805 on
NULLID.SYSLH203. I issued a bind on db2cli.lst with CLIPKG 5 . Then
after 1 hr, i got it for SYSLH205, so I bound it with CLIPKG 10
It hasn't appeared for the last 2 hrs. My question is should I change
db2cli.ini file with CLIPKG option. If yes, should each of them be with
CLIPKG=10 or should it be CLIPKG=3 each.

any input is appreciated..

Thanks

Roger
Aug 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.