motioneye
asked on
rs_helpdb show replication errors
I tried to resume the replication, but it was failed, when I checked rs_helpdb I got the status like this.
should the status ON for db involve in replication ?
what is the cause of this status goes OFF ?
1> rs_helpdb
2>
dsname dbname dbid controlling_prs status
-------------------------- ---- -------------------------- ---- ----------- -------------------------- ---- -------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----
K_Za_001 SimpliCity 122 REP_SVR Log Transfer is OFF,
(return status = 0)
should the status ON for db involve in replication ?
what is the cause of this status goes OFF ?
1> rs_helpdb
2>
dsname dbname dbid controlling_prs status
--------------------------
K_Za_001 SimpliCity 122 REP_SVR Log Transfer is OFF,
(return status = 0)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, where are you replicating from, and where are you replicating to?
ASKER
Its from sybase to sybase, but I have no idea how to identify function of each db server. Furthermore when I run admin show_connections, it does not provide me with actual server name except sybase data server only.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do we check whether its primary or replicate ? actually I have no idea how this replication get setup.