For table rebuilds using the logsegment I would like Sybase
to create a third and fourth truncation point. The third
truncation point moves at the specified save interval time.
For instance = "3TP=240 minutes". The fourth truncation
point would keep track of what needs to be backed up by a
(240 min) (last dump) (replication) (primary)
^ ^ ^ ^
3TP 4TP 2TP 1TP
Now, commands could be introduced to rebuild a table based
upon a specified timeframe from the log. The log size would
be greater, however, what would be dumped by dump
transaction (the incremental) would be about the same size.
When a database is reloaded the save_interval would be lost,
but would start holding transactions again.
I believe that with this approach Sybase could write
utilities to read the log and a table and generate the undo
What are your thoughts?
Subject: Addition of 3TP and 4TP for table level recovery
X-Mailer: WebNews to Mail Gateway v1.1s
Date: 25 Sep 2003 07:32:04 -0700
X-Trace: forums-1-dub 1064500324 10.22.241.41 (25 Sep 2003 07:32:04 -0700)
X-Original-Trace: 25 Sep 2003 07:32:04 -0700, 10.22.241.41
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1394
Article PK: 96401