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.
Checking server status (Sybase Central)
Open the multiplex folder.
Select the Servers tab to view server status. The Servers tab lists details shown in Table 2-3.
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” |
Status displays are not instantaneous and depend on network latency. To refresh the status display, select View > Refresh Folder from the main menu bar.
In a multiplex environment, users with RESOURCE authority
see coordinators in the Servers folder, rather than the Multiplex
folder.
Checking
server status (Interactive SQL)
Connect to the coordinator as a user with DBA authority, or as a user who has been assigned execute permission on the sp_iqmpxinfo procedure.
Run sp_iqmpxinfo.
For more information, see “sp_iqmpxinfo procedure”.
