syscluster

The syscluster system catalog table stores information about servers in a high-availability cluster. The syscluster table has the following columns.
Table 1. syscluster table information
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.


Copyright© 2019 HCL Technologies Limited