The suspend parameter prevents the listener from accepting any more connections. sp_listener...suspend is less drastic than sp_listener...stop because it does not close the listener port on the given engine. It only informs the listener to stop accepting connections on the given engine until further notice. sp_listener...suspend is helpful for temporarily preventing a listener from accepting connections. The listener can resume listening with the resume parameter. sp_listener...suspend fails if it is suspending the last active listener on the system.
sp_listener...suspend only affects future connections; it does not affect the connections that are active.
To suspend a listener on engine three of Adaptive Server ASE1251:
sp_listener “suspend”, ASE1251, 3
The following suspends the listener corresponding to the specified tli address for all engines on which it is not already running:
sp_listener “suspend”, “tli:ASE1251:4556”
To suspend all listeners on engines three through six that are in a state that will allow the change (assuming the server has seven engines):
sp_listener “suspend”, “ASE1251”, “remaining
