Is there a connection pooling mechanism? Could something be timing out
on big loads and cutting the connection?

Roger wrote:
> I don't think thats the case. We are running the insert process by
> itself.
>
>
> Bernd Hohmann wrote:
>> Roger wrote:
>>
>>> My dev team is getting this error when they run big load program :
>>> COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid
>>> statement handle or statement is closed. SQLSTATE=S1000
>>> .
>>> The application runs fine when they run small loads. I checked the Db2
>>> client FP..its on DV2 V8 FP10.
>> Wild guess: another thread retrieves a statement from the connection in
>> the meantime and executes it or there is only one statement handle and a
>> different threads uses this handle from time to time.
>>
>> Bernd
>>
>> --
>> What do you get when you cross a mail pigeon with a parrot ? Voice mail
>