ReConfigure/Reset Rep agent in Sybase
Sybase Replication rep agent, SybasePre-Requisite:
Sybase Server: SYB_ASE
Sybase database: DB1
Replication Server: SYB_RS
Login to SYB_ASE and run below command
use DB1
go
sp_stop_rep_agent DB1
go
sp_config_rep_agent "DB1","disable"
go
sp_config_rep_agent "DB1","enable","SYB_RS","SYB_RS_ra","SYB_RS_ra_ps"
go
dbcc settrunc(ltm,ignore)
go
Login to Replication server and get RSSD details
1>admin rssd_name
2>go
RSSD Dataserver RSSD Database
————— ————
SYB_DS SYB_RSSD
Login to RSSD Dataserver and run below command
use SYB_RSSD
go
rs_zeroltm SYB_ASE,DB1
go
Login to SYB_ASE and run below command
use DB1
go
dbcc settrunc(ltm,valid)
go
sp_start_rep_agent DB1
go
How useful was this post?
Click on a star to rate it!
Average rating 0 / 5. Vote count: 0
No votes so far! Be the first to rate this post.