how to abort session without PEMON or TDManager ?

Database
Fan

how to abort session without PEMON or TDManager ?

Dear All

Have the other ways to aborts session ?
How do I abort session by sql syntax?
,i really wanna know -*-

Br,
mnstr
Tags (1)
5 REPLIES
Teradata Employee

Re: how to abort session without PEMON or TDManager ?

In TD12.0 or later, check out the "Open API" SQL functions (documented in the Workload Management API manual).
Teradata Employee

Re: how to abort session without PEMON or TDManager ?

Worth mentioning, is that TASM supports abort capability of queries exceeding an exception threshold. This includes the "Abort on Select Only" option to avoid aborting DML and DDL queries.
N/A

Re: how to abort session without PEMON or TDManager ?

One of simplest ways is following. You can go to console and type ABORT SESSION *.USERNAME;
Enthusiast

Re: how to abort session without PEMON or TDManager ?

Hi RFiala - Can you provide an example with a session number as 123456 and username as RFiala ?
Enthusiast

Re: how to abort session without PEMON or TDManager ?

Syntax to execute abortsession.

REPLACE FUNCTION AbortSessions
(HostIdIn SMALLINT,
UserNameIn VARCHAR(30),
SessionNoIn INTEGER,
LogoffSessions VARCHAR(1),
UserOverride VARCHAR(1)
)

SELECT AbortSessions (1, 'abc', 0, 'Y', 'Y');
-- Logoff/Kill all sessions where the user abc is logged on.