Is there a way to abort Idle users after 90 min… I know about the automatic abort in conjunction with the local filter in Teradata Manager.. but it is limited to 100 users. We are looking for something on the database or Unix side without those limits… to abort specific users that are idle for 90 min… Any ideas?
You could do this through the Performance Monitor API, but you would have to have that running in order to detect the condition and abort the sessions. There is a "TimeIdle" field on the Session object that you would be able to use.
If you haven't used the PM/API before, check out Mike Dempsey's Orange Book on it. I believe the latest one is dated July 14th, 2006.