From: Bernd Hohmann on
Roger wrote:
> I am not using connection pooling. Runs on a type 4 driver. It runs for
> 1 hr and then gets the error

1hr without any traffic from or to the database?

Bernd

--
What do you get when you cross a mail pigeon with a parrot ? Voice mail
From: Knut Stolze on
Roger wrote:

> I am not using connection pooling. Runs on a type 4 driver. It runs for
> 1 hr and then gets the error

Activate a CLI trace and see what is going on with your statement handles.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
From: Roger on
thanks a trace revealed bug in the app that had close statement.

Knut Stolze wrote:
> Roger wrote:
>
> > I am not using connection pooling. Runs on a type 4 driver. It runs for
> > 1 hr and then gets the error
>
> Activate a CLI trace and see what is going on with your statement handles.
>
> --
> Knut Stolze
> DB2 z/OS Utilities Development
> IBM Germany

From: Jan Nelken on
Roger wrote:
> thanks a trace revealed bug in the app that had close statement.
>
> Knut Stolze wrote:
>> Roger wrote:
>>
>>> I am not using connection pooling. Runs on a type 4 driver. It runs for
>>> 1 hr and then gets the error

Technically speaking you were using legacy App driver - since your CLI trace was
captured.
DB2 JCC Universal Driver in T2 (Type 2) connectivity does not use CLI layer -
but uses DB2 Client code.
DB2 JCC Universal Driver in T4 (Type 4) connectivity does not use CLI layer and
does not need DB2 client code installed.

Jan M. Nelken
First  |  Prev  | 
Pages: 1 2
Prev: [IBM][JDBC Driver] CLI0601E
Next: RESOLVED