Kill session / User

[mvnrk]

Hi

How do you kill a Mload session or all sessions by specific user? Can anybody tell me exact steps on how to perform above functinality.(like from which tool/which screens)?

Here is the background of the situation:

We were loading data from ETL server(using ETL tool) using mload utility. But our mloads are hanging due to disk I/O wait in ETL server.

Thanks in advance.
mvnrk

 

[GORYN]

Hi,

if you work on a LAN :

The Gateway Global utility allows you to monitor and control the sessions of Teradata Database LAN-connected users.

KILL SESSION Terminates a specific session.
Requires using the SELECT HOST
command.

KILL USER Terminates all sessions of a specific user.
Requires using the SELECT HOST
command.

For additional information, download "Utilities - Volume 2"
from NCr teradata WEb Site and go to Chap 1.

regards

Francois