Hi all.

I'm using WebSphere 6.0 and DB2 under Windows, XADataSource(COM.ibm.db2.jdbc.DB2XADataSource from db2java.zip).
I've been trying to keep cursors open before commit (doing nested loops), but the recomended configuration (cursorhold=1) doesn't work for me.
Can anyone experienced this issue before?

>db2level
DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08024" with
level identifier "03050106".
Informational tokens are "DB2 v8.1.11.973", "s060120", "WR21365", and FixPak
"11".

Thanks.

One interesting thing. If I change to ConnectionPoolDataSOurce(not XA), it works fine.