Kill user or Session in Teradata by using Teradata Global Utility (gtwglobal)

SMP001-01:~ # tdatcmd

PDE running version is 15.10.07.11

SMP001-01:~ # gtwglobal

_______

| | |

| ___ __ ____ | ____ __|__ ____

| / |/ \ ____| ____| ____| | ____|

| --- | / | / | / | | / |

| \___ | \____| \____| \____| |__ \____|

Enter gateway command or enter h for Help:

select host 1

Host 1 has been selected.

Kill user:

Enter gateway command or enter h for Help:

1>kill user USER1

User USER1 has 1 session killed

43544401

Kill Session:

Enter gateway command or enter h for Help:

1>kill session 43547019

Session 43547019 scheduled to be killed

Displays sessions that have been successfully killed or aborted using Performance Monitoring and Production Control (PMPC) abort process:

Enter gateway command or enter h for Help:

1>display force

Host Group 1 has 2 forced sessions

Session User TimeToLive

------- ------------------------------ ----------

43544401 USER1 973 secs

43547019 USER1 1100 secs