Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Dec 2011 @ 09:39:02 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Disconnecting idle sessions
From:   Dave Wellman

Hi James,

The user may have logged on/off since then, but on other sessions. What you are seeing in PMON is only about certain sessions. You could check if the user has logged on/off during your 9 day period by looking at DBC.LOGONOFF.

Whether it is safe or not to disconnect those sessions depends on whether or not the sessions are still being used. PMON won't tell you. If you're logging all requests in DBQL then you could use that to find the time of the last request on that session.



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023