Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2010
    Posts
    56

    Unanswered: How to find a last transaction time

    Hi all,
    I need to create a screept with all the sessions number , connected to db and the last transaction time for each one of them .

    I cant find any select or snapshot , return me this details .

    Can anybody help me ?
    Tks !

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2010
    Posts
    56

    It's a general question

    I didn't send a db2 version because i'm loking for solutiion for some version :8.2,9.1,0.5,9.7 .
    Finding idle session is needed for me to resolve memory problems in a few systems and i try to create a screept to find old idle sessions , and maybe kill them automaticly .
    If there is different view to find those sessions in any versuin , i will be hapy to get it .
    Tks,

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The application snapshot has this information. Methods to access it differ between DB2 versions, I'm sure you'll be able to find them in the respective manuals.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Nov 2011
    Posts
    334
    hi.
    Did you mean to find the oldest idle applications?
    Maybe you can use the monitor element :"uow_stop_time" of the application snapshot table。

Posting Permissions

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