Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    54

    Unanswered: DB2 database session details

    Could any one will share query to get DB2 database session details including status(active or idle) and idle session time.

    what is max session limit on DB2 database?


    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2champ View Post
    Could any one will share query to get DB2 database session details including status(active or idle) and idle session time.
    GET SNAPSHOT FOR APPLICATIONS and related system views.

    Quote Originally Posted by db2champ View Post
    what is max session limit on DB2 database?
    It's configurable: max_connections - Maximum number of client connections configuration parameter - IBM DB2 9.7 for Linux, UNIX, and Windows

Tags for this Thread

Posting Permissions

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