Results 1 to 2 of 2

Thread: session id

  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Unanswered: session id

    i have a DB2 server 8.1 and I want to know (sql query) my actual session ID and the total sessions ID

    Is there any way to do that?

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by npierri
    i have a DB2 server 8.1 and I want to know (sql query) my actual session ID and the total sessions ID

    Is there any way to do that?
    Session ID? Do you mean the Application id, like from "LIST APPLICATIONS"?

    You can get that from the function application_id() in v8.2:

    db2 "values (application_id())"

    To get the info for everyone you need to use one of the snapshot table functions.

    SELECT * FROM TABLE(SNAPSHOT_APPL('MYDB', -1)) AS SNAPSHOT_APPL
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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