Sunday, December 26, 2010
- Use DB6PMHT_HD (DB6: Summary Record of Table and Index Space Statistics) table to check the database table size.
REPORT ztest_notepad. TABLES :db6pmht_hd. SELECT SINGLE * FROM db6pmht_hd WHERE stattype = 'D' "D-daily AND objectname = 'MARA' AND objecttype = 'T'. "T-table. WRITE:/ 'Table', 'MARA', 'size', db6pmht_hd-sizekb.
- To double check with above result, goto->DB02-Double click on Tables and Indexes tree node->Give table name as MARA instead * and click OK button->You will see size(KB) field
0 comments:
Post a Comment
Your useful comments, suggestions are appreciated.Your comments are moderated.