Use error.log to see a detailed problem description.
On Windows, the error log file is %SYBASE_ASE%\install\error.log, where %SYBASE_ASE and $SYBASE_ASE point to the Adaptive Server Enterprise directory in the installation location.
On UNIX, the error log file is $SYBASE_ASE/install/error.log, where %SYBASE_ASE and $SYBASE_ASE point to the Adaptive Server Enterprise directory in the installation location.
To investigate the configuration of the primary database, log in to the primary database with isql, using this syntax:
isql -S <Server_name> -U <username> -P <password>
For example, enter:
isql -S primary_db -U sa _P sa_pass
Command |
Action |
---|---|
sp_start_rep_agent <dbname> |
Start RepAgent |
sp_stop_rep_agent <dbname> |
Stop RepAgent |
sp_setreplicate <tablename>, “true” |
Set table for replication |
sp_setreplicate |
Gives status of replicated tables |
sp_setrepproc <proc_name>,function |
Set proc for replication |