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
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