Consider the following issues when you set up your warm standby application and enable replication with sp_reptostandby.
Both the active and standby databases must be managed by Adaptive Servers and must support RepAgent. Both databases must have the same disk allocations, segment names, and roles. Refer to the Adaptive Server System Administration Guide for details.
The active database name must exist in the standby server. Otherwise, replication of commands or procedures containing the name of that database will fail.
Replication Server does not support replication of DDL commands containing local variables. You must explicitly define site-specific information for these commands.
Login information is not replicated to the standby database. Refer to “Making the server user’s IDs match” for information about adding login information to the destination Replication Server.
Some commands not copied to the standby database include:
select into
update statistics
Database or configuration options such as sp_dboption and sp_configure
“Supported DDL commands and system procedures” and list the DDL commands—Transact-SQL commands and Adaptive Server system procedures—that Replication Server reproduces at the standby database when you enable replication with sp_reptostandby. An asterisk marks those commands and stored procedures whose replication is supported for Adaptive Server 12.5 and later.
alter table
create default
create index
create plan*
create procedure
create rule
create schema*
create table
create trigger
create view
drop default
drop index
drop procedure
drop rule
drop table
drop trigger
drop view
grant
installjava*
remove java*
revoke
sp_addalias
sp_addgroup
sp_addmessage
sp_add_qpgroup*
sp_adduser
sp_addtype
sp_bindefault
sp_bindmsg
sp_bindrule
sp_changegroup
sp_chgattribute
sp_commonkey
sp_config_rep_agentsp_dropalias
sp_drop_all_qplans*
sp_dropgroup
sp_dropkey
sp_dropmessage
sp_drop_qpgroup*
sp_droptype
sp_dropuser
sp_export_qpgroup*
sp_foreignkey
sp_import_qpgroup*
sp_primarykeysp_procxmode
sp_recompile
sp_rename
sp_rename_qpgroup*
sp_setrepcol
sp_setreplicate
sp_setrepmode
sp_setrepproc
sp_setreptable
sp_unbindefault
sp_unbindmsg
sp_unbindrule
To enable replication of DML and DDL commands, execute sp_reptostandby at the Adaptive Server that manages the active database. The syntax is:
sp_reptostandby dbname[, 'L1' | 'all' | 'none' ]
where dbname is the name of the active database and the keywords L1, all, and none set the level of replication support.
L1 represents the level of replication supported by Adaptive Server version 12.5.
Use the all keyword to make sure that schema replication support is always at the highest level available. For example, to set the schema replication support level to that of the latest Adaptive Server version, log in to Adaptive Server and execute this command at the isql prompt:
sp_reptostandby dbname, 'all'
Then, if the database is upgraded to a later Adaptive Server version with a higher level of replication support, all new features of that version are enabled automatically. Refer to “sp_reptostandby” in Chapter 5, “Adaptive Server Commands and System Procedures,” in the Replication Server Reference Manual for complete syntax and user information.
