Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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.


Cheers,

Dave

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



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