By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

How to determine size of a table without running statstics

P: n/a
Is there a way to calculate size of a table without runnig statistics
to use NPAGES info. In my case there are a few very large tables in the
same tablespace with very outdated stats, so LIST TABLESPACE SHOW
DETAIL won't help.

Thanks,
-Eugene

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can also consider using the INSPECT command, e.g.:

db2 inspect check database begin tbspaceid XX results keep gm.out

output file 'gm.out' spooled to diagnostic directory (e.g.
....\sqllib\db2\...on windows), then you need to parse the file:

db2inspf gm.out readfile

and you can read the 'readfile'.
You can also inspect at the table level..........

db2 inspect check table name XXXXX schema XXXX results keep gm.out

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Nov 12 '05 #2

P: n/a
Ian
ef******@gmail.com wrote:
Is there a way to calculate size of a table without runnig statistics
to use NPAGES info. In my case there are a few very large tables in the
same tablespace with very outdated stats, so LIST TABLESPACE SHOW
DETAIL won't help.


If you're running on a recent fixpack, a table snapshot will show you
the number of data and index pages for each accessed table.
Ian
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.