Sybase Adaptive Server Enterprise (primary data base)

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
Table B-1: Adaptive Server commands

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