Topic
No replies
David_DeveloperWorks
1 Post
ACCEPTED ANSWER

Pinned topic DB2 LUW WITH HOLD CURSORS and XA

‏2014-01-10T10:49:19Z |

Hi,

We use WITH HOLD cursors in an existing DB2 LUW application using DB2 XA to retain the cursor across XA COMMITs. The application however may not explicitly close the cursors.

Is there any api or call we can make to DB2 to either CLOSE all cursors or determine if any cursors are left open and their names ?

Thanks

David