• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1894
  • 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:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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