admin who_is

Displays information about Replication Server threads that are running.

Syntax

admin who_is_up [, no_trunc]

Parameters

no_trunc – Increases the size of the Info column from 40 characters to 80 characters. This is useful in displaying long data server or database names.

Examples

Example 1 –

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

Usage

For a description of the output, see admin who.

Permissions

Any user may execute this command.