A secondary login broker is not intended to be stopped once it is started until the database itself is shutdown.
It may be possible to kill the secondary login broker process, but this may cause the database to crash if the secondary broker is holding any resources needed by the database.
If an attempt to kill the secondary login broker is necessary:
- Disconnect any remote users connected to the remote servers the secondary login broker has spawned
- Terminate any remote servers the secondary login broker has spawned. Refer to Article How to terminate a remote server process?
- Block the listening port the secondary broker on the firewall, to prevent any new communication to the broker
- Send a Kill against the PID of the secondary broker
- After the broker PID is killed, unblock the port within the firewall.
To find the PID of the secondary login broker use promon:
promon <dbname>
R&D
1. Status Displays
17. Servers By Broker
Look for a LOGIN as the type and identify the port (right most column) that the broker is using.
The second column (PID) of that entry is the PID to kill.
Example:
Sv Pend. Cur. Max. Port
No Pid Type Protocol Logins Users Users Users Num
0 13432 Login TCP 0 0 0 5 8787
2 2372 Auto TCP 16 0 4 5 3000
1 11144 Login TCP 0 0 0 5 7878
3 11804 Auto TCP 3 0 1 5 3001
In the above example:
The remote user should first be disconnected:
PROMON > R&D > 1. Status Displays > 4. Processes/Clients > 6. Remote Clients
PROMON > R&D > 4. Administrative Functions > 9. Shutdown Database > 1 Disconnect a User
Remote server (3) should first be terminated, before killing the secondary login broker's pid:
PROMON > R&D > 4. Administrative Functions > 7. Server Options > 7. Terminate a server