The default configuration table name is syso_cluster, where cluster is the value of the MUTUAL_CLUSTER parameter set in the OpenSwitch server configuration file. This parameter must be the same for both OpenSwitch servers in a mutually-aware implementation.
The table name begins with “sys” so that the table cannot be replicated. This table is created in the default database for the CMON user in the Adaptive Server. When the default database is not explicitly set for the CMON user, the table is created in the master database.
If you want the table created in an Adaptive Server
database other than the master database, the administrator should
set the CMON user’s default database to a database that
is suitable for such use. The administrator must understand the
relationship between the mutually-aware OpenSwitch and this table.
When a companion OpenSwitch is not running and a mutually-aware OpenSwitch starts up, the information in the configuration table overrides the information in the OpenSwitch’s configuration file. To change this order of precedence, start the mutually-aware OpenSwitch with the “-O” option. See “Requirements”.
OpenSwitch servers from one cluster write only to the table for that cluster, and as much as possible, a write is carried out in both Adaptive Servers in an atomic fashion to ensure redundancy in the stored configuration information.
Because only one row is entered for each pool, and there can be only two pools, there are only two rows in this table.
