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 HCL 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 HCL support to monitor coordination of the primary server with the secondary server. | |