Results 1 to 5 of 5

Thread: Open cursors

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Unanswered: Open cursors

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

    Thanks !!

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    get snapshot for applications may have the answer ....
    Kill the application if you don't want the open cursors ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2003
    Posts
    294
    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 !!!

  4. #4
    Join Date
    Jun 2003
    Posts
    294
    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.

  5. #5
    Join Date
    Jun 2003
    Posts
    294
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •