Checking server status

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

StepsChecking server status (Sybase Central)

  1. Open the multiplex folder.

  2. Select the Servers tab to view server status. The Servers tab lists details shown in Table 2-3.

    Table 2-3: 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.

StepsChecking server status (Interactive SQL)

  1. Connect to the coordinator.

  2. Run sp_iqmpxinfo.

    For more information, see “sp_iqmpxinfo procedure”.