KILL Teradata Database Session

Database
Enthusiast

KILL Teradata Database Session

How can I kill any Client session with Teradata database through SQL command? In Oracle, I used one command like

ALTER SYSTEM KILL SESSION

for killing any long running or hung sessions

do Teradata have any similer command ?

1 REPLY
Senior Apprentice

Re: KILL Teradata Database Session

If your on TD12 you might use the syslib.AbortSessions UDF.

Before TD12 there's no way to kill a session using SQL, you have to use the PMon-API or some command line tool.

Dieter