Adaptive Server uses Component Integration Services (CIS) to create the proxy databases. Both the primary Adaptive Server and the secondary Adaptive Server must have CIS running before they are configured for Sybase Failover. To determine if you have CIS running, enter:
sp_configure "enable cis" Parameter Name Default Memory Used Config Value Run Value ------------------ --------- ----------- ------------ --------- enable cis 1 0 1 1
A Run Value of 1 indicates that CIS is running.
For information about configuring Adaptive Server for CIS, see the Component Integration Services User’s Guide.
CIS performs the following when it creates the proxy databases:
If you do not specify a size or a database device, estimates the size of the database required to contain all the proxy tables.
Creates all proxy tables. These act as placeholders for the tables and views found in the primary companion’s database.
Imports the metadata (column names, size, indexes, and so on) from the primary companion.
Grants all permissions on the proxy tables to public.
Adds the user guest to the proxy database.
Sets the database status to indicate that the database is a proxy database. The status is indicated in the status3 column of sysdatabases. sp_helpdb includes information about whether a database is either a proxy or primary database.
