All Forums Database
elenablack 2 posts Joined 12/14
11 Mar 2015
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!
 

Elena Black

tomnolan 594 posts Joined 01/08
11 Mar 2015

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.

You must sign in to leave a comment.