SEO

Hi Everyone,

I've got a db2 problem.
My Java program connects to a IBM Db2 8.1.3 database.

There's only 1 active connection to the database via JDBC type 4 driver.
A prepared statement is used to insert 100 to 1000 records in one sequence.
Most of the time everything works great, but sometimes an error occurs,
the -805 error.

The error description says that a package is corrupt or gone, in this
case SYSLH205 (but it's always different). I don't know what it is or
why it appears. I only use an insert statement. I never throwed anything
away.
It occurs on the production and testdatabase. So I don't think that it
has nothing to do with the installation of the database. Or that I've to
bind a package.

Has anybody a explanation why it happens? And better how it can be
solved (with a workarround is als good).

Thanx in advance,
Marcel Rokers

The code:

....
SQLins =
"INSERT INTO "
+ Constants.DB2SCHEMA
+ ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";

insertStmt = db2.getConnection().prepareStatement(SQLins);

while (...) {
...
insertStmt.setInt(1, measureID);
insertStmt.setTimestamp(2, time);
insertStmt.setFloat(3, value);
insertStmt.setInt(4, shiftID);
insertStmt.executeUpdate();
...
}
insertStmt.close();
....

The error message that occurs:

SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
NULLID.SYSLH205 0X5359534C564C3031
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
at com.ibm.db2.jcc.a.co.e(co.java:1361)
at com.ibm.db2.jcc.b.bd.o(bd.java:545)
at com.ibm.db2.jcc.b.bd.g(bd.java:124)
at com.ibm.db2.jcc.b.bd.a(bd.java:42)
at com.ibm.db2.jcc.b.r.a(r.java:31)
at com.ibm.db2.jcc.b.bp.g(bp.java:103)
at com.ibm.db2.jcc.a.co.g(co.java:968)
at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
at com.ibm.db2.jcc.a.cp.K(cp.java:316)
at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
at com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
at
com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.java:113)
at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)

Mixed client versions (fix levels)?
"Marcel" <mr_nospam@vgelder.com> wrote in message
news:3f82b9da$0$28892$1b62eedf@news.euronet.nl...
> Hi Everyone,
>
> I've got a db2 problem.
> My Java program connects to a IBM Db2 8.1.3 database.
>
> There's only 1 active connection to the database via JDBC type 4 driver.
> A prepared statement is used to insert 100 to 1000 records in one
sequence.
> Most of the time everything works great, but sometimes an error occurs,
> the -805 error.
>
> The error description says that a package is corrupt or gone, in this
> case SYSLH205 (but it's always different). I don't know what it is or
> why it appears. I only use an insert statement. I never throwed anything
> away.
> It occurs on the production and testdatabase. So I don't think that it
> has nothing to do with the installation of the database. Or that I've to
> bind a package.
>
> Has anybody a explanation why it happens? And better how it can be
> solved (with a workarround is als good).
>
> Thanx in advance,
> Marcel Rokers
>
> The code:
>
> ...
> SQLins =
> "INSERT INTO "
> + Constants.DB2SCHEMA
> + ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";
>
> insertStmt = db2.getConnection().prepareStatement(SQLins);
>
> while (...) {
> ...
> insertStmt.setInt(1, measureID);
> insertStmt.setTimestamp(2, time);
> insertStmt.setFloat(3, value);
> insertStmt.setInt(4, shiftID);
> insertStmt.executeUpdate();
> ...
> }
> insertStmt.close();
> ...
>
> The error message that occurs:
>
> SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
> NULLID.SYSLH205 0X5359534C564C3031
> com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
> 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
> at com.ibm.db2.jcc.a.co.e(co.java:1361)
> at com.ibm.db2.jcc.b.bd.o(bd.java:545)
> at com.ibm.db2.jcc.b.bd.g(bd.java:124)
> at com.ibm.db2.jcc.b.bd.a(bd.java:42)
> at com.ibm.db2.jcc.b.r.a(r.java:31)
> at com.ibm.db2.jcc.b.bp.g(bp.java:103)
> at com.ibm.db2.jcc.a.co.g(co.java:968)
> at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
> at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
> at com.ibm.db2.jcc.a.cp.K(cp.java:316)
> at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
> at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
> at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
> at
com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
> at
>
com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
a:113)
> at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)
>

Hello Mark,

That's indeed the case. The testdatabase is 8.1.3 + 8.1.2 client. The
productiondatabase is 8.1.0 + 8.1.2 client.

I'll try it right away and come back with the answer.

Thanx for your help.
Marcel

Mark Yudkin wrote:
> Mixed client versions (fix levels)?
> "Marcel" <mr_nospam@vgelder.com> wrote in message
> news:3f82b9da$0$28892$1b62eedf@news.euronet.nl...
>
>>Hi Everyone,
>>
>>I've got a db2 problem.
>>My Java program connects to a IBM Db2 8.1.3 database.
>>
>>There's only 1 active connection to the database via JDBC type 4 driver.
>>A prepared statement is used to insert 100 to 1000 records in one
>
> sequence.
>
>>Most of the time everything works great, but sometimes an error occurs,
>>the -805 error.
>>
>>The error description says that a package is corrupt or gone, in this
>>case SYSLH205 (but it's always different). I don't know what it is or
>>why it appears. I only use an insert statement. I never throwed anything
>>away.
>>It occurs on the production and testdatabase. So I don't think that it
>>has nothing to do with the installation of the database. Or that I've to
>>bind a package.
>>
>>Has anybody a explanation why it happens? And better how it can be
>>solved (with a workarround is als good).
>>
>>Thanx in advance,
>>Marcel Rokers
>>
>>The code:
>>
>>...
>>SQLins =
>> "INSERT INTO "
>>+ Constants.DB2SCHEMA
>>+ ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";
>>
>>insertStmt = db2.getConnection().prepareStatement(SQLins);
>>
>>while (...) {
>>...
>>insertStmt.setInt(1, measureID);
>>insertStmt.setTimestamp(2, time);
>>insertStmt.setFloat(3, value);
>>insertStmt.setInt(4, shiftID);
>>insertStmt.executeUpdate();
>>...
>>}
>>insertStmt.close();
>>...
>>
>>The error message that occurs:
>>
>>SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
>>NULLID.SYSLH205 0X5359534C564C3031
>>com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
>>51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
>>at com.ibm.db2.jcc.a.co.e(co.java:1361)
>>at com.ibm.db2.jcc.b.bd.o(bd.java:545)
>>at com.ibm.db2.jcc.b.bd.g(bd.java:124)
>>at com.ibm.db2.jcc.b.bd.a(bd.java:42)
>>at com.ibm.db2.jcc.b.r.a(r.java:31)
>>at com.ibm.db2.jcc.b.bp.g(bp.java:103)
>>at com.ibm.db2.jcc.a.co.g(co.java:968)
>>at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
>>at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
>>at com.ibm.db2.jcc.a.cp.K(cp.java:316)
>>at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
>>at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
>>at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
>>at
>
> com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
>
>>at
>>
>
> com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
> a:113)
>
>>at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)
>>
>
>
>

Yes, that'll cause the problem.

OTOH, package versioning in DB2 V8 was supposed to finally get rid of these
issues. You may like to open a PMR.

"Marcel" <mr_nospam@vgelder.com> wrote in message
news:3f8a72ce$0$64179$1b62eedf@news.euronet.nl...
> Hello Mark,
>
> That's indeed the case. The testdatabase is 8.1.3 + 8.1.2 client. The
> productiondatabase is 8.1.0 + 8.1.2 client.
>
> I'll try it right away and come back with the answer.
>
> Thanx for your help.
> Marcel
>
> Mark Yudkin wrote:
> > Mixed client versions (fix levels)?
> > "Marcel" <mr_nospam@vgelder.com> wrote in message
> > news:3f82b9da$0$28892$1b62eedf@news.euronet.nl...
> >
> >>Hi Everyone,
> >>
> >>I've got a db2 problem.
> >>My Java program connects to a IBM Db2 8.1.3 database.
> >>
> >>There's only 1 active connection to the database via JDBC type 4 driver.
> >>A prepared statement is used to insert 100 to 1000 records in one
> >
> > sequence.
> >
> >>Most of the time everything works great, but sometimes an error occurs,
> >>the -805 error.
> >>
> >>The error description says that a package is corrupt or gone, in this
> >>case SYSLH205 (but it's always different). I don't know what it is or
> >>why it appears. I only use an insert statement. I never throwed anything
> >>away.
> >>It occurs on the production and testdatabase. So I don't think that it
> >>has nothing to do with the installation of the database. Or that I've to
> >>bind a package.
> >>
> >>Has anybody a explanation why it happens? And better how it can be
> >>solved (with a workarround is als good).
> >>
> >>Thanx in advance,
> >>Marcel Rokers
> >>
> >>The code:
> >>
> >>...
> >>SQLins =
> >> "INSERT INTO "
> >>+ Constants.DB2SCHEMA
> >>+ ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";
> >>
> >>insertStmt = db2.getConnection().prepareStatement(SQLins);
> >>
> >>while (...) {
> >>...
> >>insertStmt.setInt(1, measureID);
> >>insertStmt.setTimestamp(2, time);
> >>insertStmt.setFloat(3, value);
> >>insertStmt.setInt(4, shiftID);
> >>insertStmt.executeUpdate();
> >>...
> >>}
> >>insertStmt.close();
> >>...
> >>
> >>The error message that occurs:
> >>
> >>SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
> >>NULLID.SYSLH205 0X5359534C564C3031
> >>com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
> >>51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
> >>at com.ibm.db2.jcc.a.co.e(co.java:1361)
> >>at com.ibm.db2.jcc.b.bd.o(bd.java:545)
> >>at com.ibm.db2.jcc.b.bd.g(bd.java:124)
> >>at com.ibm.db2.jcc.b.bd.a(bd.java:42)
> >>at com.ibm.db2.jcc.b.r.a(r.java:31)
> >>at com.ibm.db2.jcc.b.bp.g(bp.java:103)
> >>at com.ibm.db2.jcc.a.co.g(co.java:968)
> >>at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
> >>at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
> >>at com.ibm.db2.jcc.a.cp.K(cp.java:316)
> >>at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
> >>at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
> >>at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
> >>at
> >
> > com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
> >
> >>at
> >>
> >
> >
com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
> > a:113)
> >
> >>at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)
> >>
> >
> >
> >
>

Mark,

This is the solution. The -805 doesn't occur anymore in production and
in the testenvironment.

In test I now use 8.1.3 + 8.1.3 JDBC client.
In production I now use 8.1.0 + 8.1.0 JDBC client.

But now I can't have the complete program packaged anymore inluding the
JDBC driver. But you can't have it all......

Thanx a lot,
this problem has cost me serious headtroubles.
Marcel

PS. What means a PMR (a bugreport I asume?)???

Mark Yudkin wrote:

> Yes, that'll cause the problem.
>
> OTOH, package versioning in DB2 V8 was supposed to finally get rid of these
> issues. You may like to open a PMR.
>
> "Marcel" <mr_nospam@vgelder.com> wrote in message
> news:3f8a72ce$0$64179$1b62eedf@news.euronet.nl...
>
>>Hello Mark,
>>
>>That's indeed the case. The testdatabase is 8.1.3 + 8.1.2 client. The
>>productiondatabase is 8.1.0 + 8.1.2 client.
>>
>>I'll try it right away and come back with the answer.
>>
>>Thanx for your help.
>>Marcel
>>
>>Mark Yudkin wrote:
>>
>>>Mixed client versions (fix levels)?
>>>"Marcel" <mr_nospam@vgelder.com> wrote in message
>>>news:3f82b9da$0$28892$1b62eedf@news.euronet.nl. ..
>>>
>>>
>>>>Hi Everyone,
>>>>
>>>>I've got a db2 problem.
>>>>My Java program connects to a IBM Db2 8.1.3 database.
>>>>
>>>>There's only 1 active connection to the database via JDBC type 4 driver.
>>>>A prepared statement is used to insert 100 to 1000 records in one
>>>
>>>sequence.
>>>
>>>
>>>>Most of the time everything works great, but sometimes an error occurs,
>>>>the -805 error.
>>>>
>>>>The error description says that a package is corrupt or gone, in this
>>>>case SYSLH205 (but it's always different). I don't know what it is or
>>>>why it appears. I only use an insert statement. I never throwed anything
>>>>away.
>>>>It occurs on the production and testdatabase. So I don't think that it
>>>>has nothing to do with the installation of the database. Or that I've to
>>>>bind a package.
>>>>
>>>>Has anybody a explanation why it happens? And better how it can be
>>>>solved (with a workarround is als good).
>>>>
>>>>Thanx in advance,
>>>>Marcel Rokers
>>>>
>>>>The code:
>>>>
>>>>...
>>>>SQLins =
>>>> "INSERT INTO "
>>>>+ Constants.DB2SCHEMA
>>>>+ ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";
>>>>
>>>>insertStmt = db2.getConnection().prepareStatement(SQLins);
>>>>
>>>>while (...) {
>>>>...
>>>>insertStmt.setInt(1, measureID);
>>>>insertStmt.setTimestamp(2, time);
>>>>insertStmt.setFloat(3, value);
>>>>insertStmt.setInt(4, shiftID);
>>>>insertStmt.executeUpdate();
>>>>...
>>>>}
>>>>insertStmt.close();
>>>>...
>>>>
>>>>The error message that occurs:
>>>>
>>>>SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
>>>>NULLID.SYSLH205 0X5359534C564C3031
>>>>com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE:
>>>>51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
>>>>at com.ibm.db2.jcc.a.co.e(co.java:1361)
>>>>at com.ibm.db2.jcc.b.bd.o(bd.java:545)
>>>>at com.ibm.db2.jcc.b.bd.g(bd.java:124)
>>>>at com.ibm.db2.jcc.b.bd.a(bd.java:42)
>>>>at com.ibm.db2.jcc.b.r.a(r.java:31)
>>>>at com.ibm.db2.jcc.b.bp.g(bp.java:103)
>>>>at com.ibm.db2.jcc.a.co.g(co.java:968)
>>>>at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
>>>>at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
>>>>at com.ibm.db2.jcc.a.cp.K(cp.java:316)
>>>>at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
>>>>at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
>>>>at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
>>>>at
>>>
>>>com.vge.pps.background.CurrentMeasure.saveToDis k(CurrentMeasure.java:98)
>>>
>>>
>>>>at
>>>>
>>>
>>>
> com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
>
>>>a:113)
>>>
>>>
>>>>at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)
>>>>
>>>
>>>
>>>
>
>

Hi,

In a current discussion (16-5-2003) about -805 error I found the command:
db2jdbcbind -url jdbc:db2://127.0.0.1:50000/xxx -user xxx -password xxxx
-size 20

I used it in testenvironment (never known it before) and a lot of
packages where created. So I think that it's the real solution.
I'm going to mix clientversion and see the effect on it.

Greetz,
Marcel

Marcel wrote:

> Mark,
>
> This is the solution. The -805 doesn't occur anymore in production and
> in the testenvironment.
>
> In test I now use 8.1.3 + 8.1.3 JDBC client.
> In production I now use 8.1.0 + 8.1.0 JDBC client.
>
> But now I can't have the complete program packaged anymore inluding the
> JDBC driver. But you can't have it all......
>
> Thanx a lot,
> this problem has cost me serious headtroubles.
> Marcel
>
> PS. What means a PMR (a bugreport I asume?)???
>
> Mark Yudkin wrote:
>
>> Yes, that'll cause the problem.
>>
>> OTOH, package versioning in DB2 V8 was supposed to finally get rid of
>> these
>> issues. You may like to open a PMR.
>>
>> "Marcel" <mr_nospam@vgelder.com> wrote in message
>> news:3f8a72ce$0$64179$1b62eedf@news.euronet.nl...
>>
>>> Hello Mark,
>>>
>>> That's indeed the case. The testdatabase is 8.1.3 + 8.1.2 client. The
>>> productiondatabase is 8.1.0 + 8.1.2 client.
>>>
>>> I'll try it right away and come back with the answer.
>>>
>>> Thanx for your help.
>>> Marcel
>>>
>>> Mark Yudkin wrote:
>>>
>>>> Mixed client versions (fix levels)?
>>>> "Marcel" <mr_nospam@vgelder.com> wrote in message
>>>> news:3f82b9da$0$28892$1b62eedf@news.euronet.nl...
>>>>
>>>>
>>>>> Hi Everyone,
>>>>>
>>>>> I've got a db2 problem.
>>>>> My Java program connects to a IBM Db2 8.1.3 database.
>>>>>
>>>>> There's only 1 active connection to the database via JDBC type 4
>>>>> driver.
>>>>> A prepared statement is used to insert 100 to 1000 records in one
>>>>
>>>>
>>>> sequence.
>>>>
>>>>
>>>>> Most of the time everything works great, but sometimes an error
>>>>> occurs,
>>>>> the -805 error.
>>>>>
>>>>> The error description says that a package is corrupt or gone, in this
>>>>> case SYSLH205 (but it's always different). I don't know what it is or
>>>>> why it appears. I only use an insert statement. I never throwed
>>>>> anything
>>>>> away.
>>>>> It occurs on the production and testdatabase. So I don't think that it
>>>>> has nothing to do with the installation of the database. Or that
>>>>> I've to
>>>>> bind a package.
>>>>>
>>>>> Has anybody a explanation why it happens? And better how it can be
>>>>> solved (with a workarround is als good).
>>>>>
>>>>> Thanx in advance,
>>>>> Marcel Rokers
>>>>>
>>>>> The code:
>>>>>
>>>>> ...
>>>>> SQLins =
>>>>> "INSERT INTO "
>>>>> + Constants.DB2SCHEMA
>>>>> + ".VALUE (MeasureID, Time, Value, shiftID) VALUES (?, ?, ?, ?)";
>>>>>
>>>>> insertStmt = db2.getConnection().prepareStatement(SQLins);
>>>>>
>>>>> while (...) {
>>>>> ...
>>>>> insertStmt.setInt(1, measureID);
>>>>> insertStmt.setTimestamp(2, time);
>>>>> insertStmt.setFloat(3, value);
>>>>> insertStmt.setInt(4, shiftID);
>>>>> insertStmt.executeUpdate();
>>>>> ...
>>>>> }
>>>>> insertStmt.close();
>>>>> ...
>>>>>
>>>>> The error message that occurs:
>>>>>
>>>>> SEVERE: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC:
>>>>> NULLID.SYSLH205 0X5359534C564C3031
>>>>> com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805,
>>>>> SQLSTATE:
>>>>> 51002, SQLERRMC: NULLID.SYSLH205 0X5359534C564C3031
>>>>> at com.ibm.db2.jcc.a.co.e(co.java:1361)
>>>>> at com.ibm.db2.jcc.b.bd.o(bd.java:545)
>>>>> at com.ibm.db2.jcc.b.bd.g(bd.java:124)
>>>>> at com.ibm.db2.jcc.b.bd.a(bd.java:42)
>>>>> at com.ibm.db2.jcc.b.r.a(r.java:31)
>>>>> at com.ibm.db2.jcc.b.bp.g(bp.java:103)
>>>>> at com.ibm.db2.jcc.a.co.g(co.java:968)
>>>>> at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
>>>>> at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
>>>>> at com.ibm.db2.jcc.a.cp.K(cp.java:316)
>>>>> at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
>>>>> at com.vge.pps.domain.Value.saveToDisk(Value.java:65)
>>>>> at com.vge.pps.domain.ValueList.saveToDisk(ValueList. java:200)
>>>>> at
>>>>
>>>>
>>>> com.vge.pps.background.CurrentMeasure.saveToDisk(C urrentMeasure.java:98)
>>>>
>>>>
>>>>
>>>>> at
>>>>>
>>>>
>>>>
>> com.vge.pps.background.CurrentMeasureList.transfer All(CurrentMeasureList.jav
>>
>>
>>>> a:113)
>>>>
>>>>
>>>>> at com.vge.pps.background.MeasureThread.run(MeasureTh read.java:58)
>>>>>
>>>>
>>>>
>>>>
>>
>>
>

Hello,

i have the same error happend after i run our application for a while.
my server is db2 v8.1 windows 64 bit with fix pack3. it asks for
package SYSLH203.i don't think there is one exist. i have tried to do
db2jdbcbind for size 60, the maxappls is 60. what else i can do to fix
this problem? i don't know what is jdbc client. our application just
use db2jcc driver to connect to server database. is this problem
related to client? i am using db2jcc jar come from the fix pack.
please help !!!

If a BIND doesn't help (i.e. SYSLH203 doesn't exist), you'll have to open a
PMR.
"xixi" <dai_xi@yahoo.com> wrote in message
news:c0f33a17.0310170713.6c82f7@posting.google.com ...
> Hello,
>
> i have the same error happend after i run our application for a while.
> my server is db2 v8.1 windows 64 bit with fix pack3. it asks for
> package SYSLH203.i don't think there is one exist. i have tried to do
> db2jdbcbind for size 60, the maxappls is 60. what else i can do to fix
> this problem? i don't know what is jdbc client. our application just
> use db2jcc driver to connect to server database. is this problem
> related to client? i am using db2jcc jar come from the fix pack.
> please help !!!

sorry, we are just have DB2 trial version. is there we still can
submit the PMR? (what does it represent?)

thanks

You need a valid service and support contract to submit a problem report
(PMR). If it is definitely a DB2 defect, and you can submit a test case
which we can easily reproduce, we can look at getting this officially
recognized as a an APAR (Authorized Program Analysis Report - fancy word
for defect). But, it will be very hard to provide you with fixes or
problem analysis until you purchase the support contract.

xixi wrote:

> sorry, we are just have DB2 trial version. is there we still can
> submit the PMR? (what does it represent?)
>
> thanks