Displays information about Replication Server threads that are running.
admin who_is_up
admin who_is_up
Spid Name State Info ---- -------- --------------- -------------------- 97 DIST Active 103 LDS.pubs2 98 SQT Awaiting Wakeup 103:1 DIST LDS.pubs2 96 SQM Awaiting Message 103:1 LDS.pubs2 68 SQM Awaiting Message 103:0 LDS.pubs2 89 DSI EXEC Awaiting Message 106(1) SYDNEY_DS.pubs2sb 91 DSI Awaiting Command 106 SYDNEY_DS.pubs2sb 21 DSI EXEC Awaiting Message 101(1) TOKYO_DS.TOKYO_RSSD 10 DSI Awaiting Command 101 TOKYO_DS.TOKYO_RSSD 16 DIST Active 101 TOKYO_DS.TOKYO_RSSD 17 SQT Active 101:1 DIST TOKYO_DS.TOKYO 15 SQM Awaiting Message 101:1 TOKYO_DS.TOKYO_RSSD 14 SQM Awaiting Message 103:1 TOKYO_DS.TOKYO_RSSD 30 REP AGENT Awaiting Command TOKYO_DS.TOKYO_RSSD USER 4 DSI EXEC Awaiting Message 104(1) TOKYO_DS.pubs2 9 dAIO Awaiting Message 12 dREC Active dREC 61 USER Active sa 5 dALARM Awaiting Wakeup
For a description of the output, see admin who.
Any user may execute this command.
