Disconnected sessions not releasing from PE


Disconnected sessions not releasing from PE

We have a user who attempts to logon to Teradata from an application with wrong password. While checking in the LogonOff table, we do not see any successful logon from the user. However, when checking in gtwglobal, we can see disconnected sessions from this user. The TimeToLive reduces, however when it becomes 0, it starts from 1200 again. We tried to abort these sessions from gtwglobal, and we got a message saying the sessions were aborted. But when we check again for disconnected sessions, it displays all the sessions again.

Has anyone faced similar issue before? If yes, what can we do to get these sessions out of the box?

Our database is version 13.10.



Tags (1)