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 you can configure them for Sybase Failover.
CIS does not import column defaults that exist in the primary database into the proxy table.
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.
When it creates the proxy databases, CIS:
Estimates the size of the database required to contain all the proxy tables if a size or database device is not specified.
Creates all proxy tables. Proxy tables 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 a proxy or primary database.
