SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:38 AM
| ||||
| ||||
 getting -805 for SYSLH203 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      |
|
02-27-2008, 07:38 AM
| |||
| |||
| Re: getting -805 for SYSLH203 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 |
|
02-27-2008, 07:49 AM
| ||||
| ||||
| Re: getting -805 for SYSLH203 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 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 |
Linear Mode
