MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

table size

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
javedsk12
Beginner


Joined: 14 Dec 2007
Posts: 66
Topics: 36
Location: pune

PostPosted: Thu Feb 21, 2008 3:51 am    Post subject: table size Reply with quote

hi frnds,

How to find out the size of a table
_________________
javed

-----------------------
The Word Impossible it self says i am possible(im possible)
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Thu Feb 21, 2008 4:12 am    Post subject: Reply with quote

size - what do you mean?
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
javedsk12
Beginner


Joined: 14 Dec 2007
Posts: 66
Topics: 36
Location: pune

PostPosted: Thu Feb 21, 2008 4:17 am    Post subject: Reply with quote

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

-----------------------
The Word Impossible it self says i am possible(im possible)
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Fri Feb 22, 2008 7:50 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
videlord
Beginner


Joined: 09 Dec 2004
Posts: 147
Topics: 19

PostPosted: Fri Feb 22, 2008 10:54 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group