Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    10

    Unanswered: How to find session ID in DB2

    Can anyone tell me how to get the session ID in DB2 ? Thank you for your helping. I can only get session ID in oracle T.T , but don't know how to get in DB2. The version of DB2 is V8.2.

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    If you are talking about the id of the current session then you can try the following:

    db2 "select application_id() as appl_id from sysibm.sysdummy1"

    Thanks,
    Jayanta Datta
    New Delhi, India

  3. #3
    Join Date
    Apr 2006
    Posts
    10
    thanks !! It really help me !

Posting Permissions

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