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 

Comments