Amazon books

Monday, October 28, 2013

Using log dump to find operations in a table between interval time - GoldenGate

1-Open the trace file

Logdump 2 >open eb000025
Current LogTrail is /ggshop/bwdhdbpr025/gghome/dirdat/eb000025

2-Set time interval
Logdump 4 >filter starttime 2013-10-28 11:30
Logdump 5 >filter endtime 2013-10-28 11:59

3-Match all tables and show
Logdump 6 >filter match all
Logdump 7 >filter show
Logdump 8 >count

4-Or check for only one table
Logdump 11 >filter filename TABLE_NAME

####################################################
###### Output example ######
####################################################
SCHEMA.TABLE1                       Partition 4
Total Data Bytes             70524
  Avg Bytes/Record            1410
Insert                          16
LargeObject                     34
After Images                    50
####################################################



Best Regards,
Paulo Portugal

No comments:

Post a Comment