syscluster
The syscluster system catalog table stores information
about servers in a high-availability cluster. The syscluster table
has the following columns.
Column | Type | Explanation | |
---|---|---|---|
name | CHAR(128) | The name of the primary server. | |
role | CHAR(1) | Code to indicate whether the server is a primary server or secondary server. | |
syncmode | CHAR(8) | The synchronization mode between the primary server and the secondary server: sync or async. | |
nodetype | CHAR(8) | The type of server: HDR, RSS, or SDS. | |
supports_updates | CHAR(1) | Indicates whether client applications can perform update, insert, and delete operations on the secondary server (as specified by the UPDATABLE_SECONDARY configuration parameter). | |
server_status | CHAR(32) | Indicates the status of the secondary server. | |
connection_status | CHAR(32) | Indicates the connection status of the secondary server. | |
delayed_apply | INTEGER | Indicates whether the secondary server waits for a specified amount of time before applying logs (as specified by the DELAY_APPLY configuration parameter). | |
stop_apply | CHAR(24) | Indicates whether the secondary server has stopped applying log files received from the primary server (as specified by the STOP_APPLY configuration parameter). | |
logid_sent | INTEGER | Indicates the log ID of the most recent log page sent by the primary server to the secondary server. | |
logpage_sent | INTEGER | Indicates the page number of the most recent log page sent by the primary server to the secondary server. | |
logid_acked | INTEGER | Indicates the log ID of the most recent log page the secondary server acknowledged. | |
logpage_acked | INTEGER | Indicates the page number of the most recent log page the secondary server acknowledged. | |
ack_time | DATETIME YEAR TO SECOND | Indicates the date and time of the last acknowledged log. | |
sdscycle | INTEGER | Indicates the cycle number to which the primary server has advanced. Used internally by IBM® support to monitor coordination of the primary server with the secondary server. | |
sdscycle_acked | INTEGER | Indicates the cycle number that the shared disk secondary server has acknowledged. Used internally by IBM support to monitor coordination of the primary server with the secondary server. |