• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1812
  • Last Modified:

sybase replication(secondary) truncation point

i know this is not new ..could you please tell me how to check if secondary point (replication truncation point) is moving or not ??????????????????

2 Solutions
Joe WoodhousePrincipal ConsultantCommented:
You do this in ASE (not in RS).

In the master database there is a table called syslogshold. This will have zero, one or two rows per database. Zero rows means the database is not replicated and there are no open (uncommitted) transactions in that database. Two rows means both (replication and uncommitted transactions). One row means either, but if you know the database is not replicated, then it has to be an open transaction... and if you know for sure there are no open transactions, then it must be the replication secondary truncation point.

Or if that's too complicated, have a look at the xactid column. This will always be 0x000000 for the RS truncation point. Also the "name" column will be "$replication_truncation_point" which is usually how I tell which is which. :)

You can tell if it's moving by looking at the "page" column. This refers to the page number of the log page the truncation marker is currently on. If the marker is moving, this column will change. (Not necessarily get sequentially larger, or even larger at all.)


I don't know if this you need...

--ase server:
use <db_name>
dbcc gettrunc

refer page: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.rs_15.0.refman/html/refman/refman232.htm.
Deepak_FILAuthor Commented:

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now