Checking Server Status in Sybase Central

After you add the first secondary server, the database is enabled for multiplex. You can then check the status of all the multiplex nodes, if desired.

  1. Open the multiplex folder.
  2. Select the Servers tab to view server status.
    Servers tab content

    Column

    Description

    Name

    Server name

    Role

    Coordinator, Reader, or Writer.

    IsConnected

    Yes if server is connected. Otherwise No. Indicates whether Sybase Central has a connection to the server. Sybase Central only needs a connection to one of the servers in the multiplex, but the user may connect Sybase Central to more than one.

    Failover node

    Yes if this is the designated failover node, otherwise No.

    Sync State

    Synchronized, Unsynchronized (not a valid state), Excluded, Coordinator, or Not Running

    As Of

    When the displayed information was last updated. For example: “8/5/08 7:01:18 PM”

  3. Status displays are not instantaneous and depend on network latency. To refresh the status display, select View > Refresh Folder from the main menu bar.
Note: In a multiplex environment, users with RESOURCE authority see coordinators in the Servers folder, rather than the Multiplex folder.
Related reference
sp_iqmpxinfo Procedure