MVSFORUMS.com

javedsk12 · Posted: Thu Feb 21, 2008 3:51 am Post subject: table size

hi frnds,

How to find out the size of a table
_________________
javed

-----------------------
The Word Impossible it self says i am possible(im possible)

dbzTHEdinosauer · Posted: Thu Feb 21, 2008 4:12 am Post subject:

size - what do you mean?
_________________
Dick Brenholtz
American living in Varel, Germany

javedsk12 · Posted: Thu Feb 21, 2008 4:17 am Post subject:

how much space that table has occupied ???
_________________
javed

-----------------------
The Word Impossible it self says i am possible(im possible)

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

The size of the table: SYSIBM.SYSTABLES.NPAGES * the pagesize of the tablespace you created the table in.

The size of the tablespace: SYSIBM.SYSTABLESPACE.SPACE.

What about the size the indexes of your table consume: Take the sum of SYSIBM.INDEXES.SPACE for all indexes of your table.

All values are of course only valid if you are current on RUNSTATS and STOSPACE.

regards
Christian

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

table is the logical structure, tablespace is the physical entity
if one table per tablespace, it's easy to get the space
1. check sysibm.systablepart (for ts) sysibm.sysindexes (for ix)
those inforation are updated by RUNSTATS, STOSPACE utility
2. check RTS table sysibm.tablespacestats, sysibm.indexspacestats
if RTS enabled
3. check the tablespace/indexspace datasets
with LISTCAT command, you can see the detail usage

if mutilple table in one tablespace, the only way i think is calculation by yourself,
get the row number, get the average row length
you can get the estimation formular from adminstrator guide