Unix Technical Forum

Question about truncation point move

This is a discussion on Question about truncation point move within the Sybase forums, part of the Database Server Software category; --> Question about truncation point move Hi, I got confused about "truncation point move"... 1. secondary truncation point move only ...


Go Back   Unix Technical Forum > Database Server Software > Sybase

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 04:10 PM
Dan
 
Posts: n/a
Default Question about truncation point move

Question about truncation point move


Hi,

I got confused about "truncation point move"...

1. secondary truncation point move only if submit to RS successfully
(IBQ). even if it has not commited?
or it should only move if apply to RDB successfully or OBQ succesfully
(fully commited)

2. when will primary truncation point move? After it commited in PDB?
what does " has finished processing." mean?


attached here is the info I got from Sybase Web site and fast track to
rep

sorry for the simple questions and thank you very much,



Dan

************************************************
1.Each primary database maintains primary and secondary truncation
points in its database log. The primary truncation point marks the
last log record Adaptive Server has finished processing. The secondary
truncation point normally marks the log record that contains the begin
transaction command for the oldest open transaction not yet fully
applied by Replication Server. Replication Server stores a copy of the
latest secondary truncation point in the rs_locater table of the

2.once records are written to the IBQ, Rreplication Server notifies
the repagent so that it can move the secondary truncation point in the
PDB log.

3.truncation point
An Adaptive Server database that holds primary data has an active
truncation point, marking the transaction log location where Adaptive
Server has completed processing. This is the primary truncation point.

The RepAgent for an Adaptive Server database maintains a secondary
truncation point, marking the transaction log location separating the
portion of the log successfully submitted to the Replication Server
from the portion not yet submitted. The secondary truncation point
ensures that each operation enters the replication system before its
portion of the log is truncated.



************************************************
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:18 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com