sybase replication(secondary) truncation point

Posted on 2010-01-05
Last Modified: 2012-05-08
i know this is not new ..could you please tell me how to check if secondary point (replication truncation point) is moving or not ??????????????????

Question by:Deepak_FIL
    LVL 24

    Accepted Solution

    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.)

    LVL 4

    Assisted Solution


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

    --ase server:
    use <db_name>
    dbcc gettrunc

    refer page:
    LVL 2

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    For Sennheiser, comfort, quality and security are high priority areas. This paper addresses the security of Bluetooth technology and the supplementary security that Sennheiser’s Contact Center and Office (CC&O) headsets provide.  
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video discusses moving either the default database or any database to a new volume.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now