Open cursors

jortiz · #1 (**permalink**) 09-01-04, 12:04

Hello, is there any way to see the current open cursors, and how to clese them ??

Thanks !!

sathyaram_s · #2 (**permalink**) 09-01-04, 18:31

get snapshot for applications may have the answer ....
Kill the application if you don't want the open cursors ...

jortiz · #3 (**permalink**) 09-02-04, 11:32

I don't really know how to get the snapshot ? could you give me any sentence to do It and later kill the application ?

Thanks !!!

jortiz · #4 (**permalink**) 09-02-04, 12:18

I'm using iseries, so I think I can't use DB2 monitor to see current open cursors, I would need something like a select clause or anything else, to be able to close them or at least to kill them.

jortiz · #5 (**permalink**) 09-02-04, 12:28

I'm using iseries, so I think I can't use DB2 monitor to see current open cursors, I would need something like a select clause or anything else, to be able to close them or at least to kill them.

Internet Services

Web Development

Digital Marketing

Consumer Tech