Using LOGDUMP GoldenGate Example

This is what I do to find the line where the replicat golden gate process abended:


Logdump 277 >open ./dirdat/pa000376
Current LogTrail is /ggshop/glete/gghome/dirdat/pa000376
Logdump 278 >ghdr on
Logdump 279 >detail data
Logdump 280 >usertoken detail
Logdump 281 >ggstokens detail
Logdump 282 >ghdr on
Logdump 283 >detail on
Logdump 284 >detail data
Logdump 285 >usertoken detail
Logdump 286 >ggstoken detail
Logdump 287 >pos 19930247
Reading forward from RBA 19930247
Logdump 288 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 46 (x002e) IO Time : 2014/07/25 16:09:52.963.776
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 38756 AuditPos : 144659472
Continued : N (x00) RecCount : 1 (x01)

2014/07/25 16:09:52.963.776 FieldComp Len 46 RBA 19930247
Name: SALES_SHOP_ADMIN.FN_PROPERTY_CONFIG
After Image: Partition 4 G s
0000 0016 0000 0012 5553 455f 494e 5355 5241 4e43 | ........USE_INSURANC
455f 4c49 5354 0001 0008 0000 0004 7472 7565 0004 | E_LIST........true..
0004 ffff 0000 | ......
Column 0 (x0000), Len 22 (x0016)
0000 0012 5553 455f 494e 5355 5241 4e43 455f 4c49 | ....USE_INSURANCE_LI
5354 | ST
Column 1 (x0001), Len 8 (x0008)
0000 0004 7472 7565 | ....true
Column 4 (x0004), Len 4 (x0004)
ffff 0000 | ....

GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4178 5a45 4141 7441 414a 6149 4d41 4145 0001 | AAAxZEAAtAAJaIMAAE..
TokenID x4c 'L' LOGCSN Info x00 Length 13
3832 3834 3735 3335 3036 3637 38 | 8284753506678
TokenID x36 '6' TRANID Info x00 Length 13
3134 342e 3234 2e33 3738 3536 35 | 144.24.378565

Logdump 289 >exit

Best Regards,

Paulo Portugal