469,354 Members | 2,035 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,354 developers. It's quick & easy.

How to determine size of a table without running statstics

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
2 1476
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
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.

Similar topics

7 posts views Thread by Bart Torbert | last post: by
2 posts views Thread by Kums | last post: by
21 posts views Thread by Joakim Hove | last post: by
9 posts views Thread by Adam | last post: by
45 posts views Thread by charles.lobo | last post: by
1 post views Thread by ara.t.howard | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.