kill ALL connections to Teradata appliance?

Database

kill ALL connections to Teradata appliance?

hello,

as part of a dr test, we would like to be able to kill all connections to one of our Teradata appliances so that all connections would then be forced to go to another appliance. is there a way to do that (for instance, in oracle, one can stop the listeners).

thanks!

1 REPLY
Teradata Employee

Re: kill ALL connections to Teradata appliance?

The Gateway Global utility, gtwglobal, has a DISABLE LOGONS command, which prevents new logons.

For killing existing sessions, it has a DISPLAY GTW command to list all sessions, and a KILL SESSION command.