Archives of the TeradataForum

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

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

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>>