Kbase P128467: How to determine the correct ai extent number to apply to target first?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/17/2008 |
|
Status: Verified
GOAL:
How to determine the correct ai extent number to apply to target first?
GOAL:
Which extent to use for dsrutil target -C ApplyExtent
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Replication 10.x
FIX:
Provided these are still available, before transitioning the target database, it may be necessary to first apply remaining LOCKED source ai extents that have not yet been applied to the replication enabled target database.
In order to achieve this, information from the output of "dsrutil target -C recovery agent" needs to be triangulated.
Example:
Replication local agent information:
Last Block: Incomplete
Last block received location: area: 16, seq: 119, loc: 2736128, offset: 0
Last block processed location: area: 0, seq: 0, loc: 0, offset: 0
Last block ACKed location: area: 16, seq: 119, loc: 819200, offset: 0
Last block received: no date
Last block ACKed: no date
ID of the last TX begin: 366
ID of the last TX end: 367
Time of last TX end: Tue Jan 22 12:53:20 2008
Last AI Extent processed
AIMAGE BEGIN date: Tue Jan 22 12:35:34 2008
AIMAGE NEW date: Tue Jan 22 12:53:00 2008
After-Image File Number: 119
File Last Opened: Tue Jan 22 12:53:00 2008
Completely Applied to Target: No
METHOD#1:
Last block ACKed location: area: 16, seq: 119, loc: 819200, offset: 0
Effectively, each ai file is given a Storage Area Number. In this example "area:16" equates to the 4th ai file: source.a4.
The following VST code can be used to record the ai extent area numbers:
FOR EACH _area WHERE _area._area-type =7 NO-LOCK:
DISPLAY _area._area-name _area._area-num .
END.
METHOD#2:
After-Image File Number: 119
is the ai SEQUENCE number 119
Scan the ai files with the cmd: rfutil source -C aimage scan -a D:\101B\WRK\repl\source\source.a4
Parse the output of this for the sequence number is reflected in the database lg file message:
This is aimage file number 9 since the last AIMAGE BEGIN. (1642)
METHOD#3:
AIMAGE NEW date: Tue Jan 22 12:53:00 2008
Parse the source.lg file (if available) for the timestamp + 3777 messages. Confirm the 3778 message with the sequence number above.
12:53:00.026+0100] P-3420 T-800 I Usr 5: (3777) Switched to ai extent D:\101B\WRK\repl\source\source.a4.
12:53:00.026+0100] P-3420 T-800 I Usr 5: (3778) This is after-image file number 9 since the last AIMAGE BEGIN
Bug# OE00164214 has been logged for consideration in future products to include the after-image file name.