getting -805 for SYSLH203

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger - 11 Jul 2006 16:48 GMT

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

Reply to this Message

Shashi Mannepalli - 11 Jul 2006 19:03 GMT

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

> 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
[quoted text clipped - 11 lines]
>
> Roger

Reply to this Message

Roger - 07 Aug 2006 17:02 GMT

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 <dbname> I 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

> If the packages are bound to the database then u don't need to change
> in db2cli.ini.
[quoted text clipped - 23 lines]
> >
> > Roger

Reply to this Message