How to determine size of a table without running statstics

[efiryago]

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

[graham_martin]

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/

[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