Estimating table size using sysmaster

All, I would like to devise a way of determining the table size of a table using the sysmaster database preferably but I don´t mind another place as long as it uses SQL. By table size I mean the inclusion of BLOB pages, index pages etc etc. I have looked at sysextents, systabextents and some others and they seem to exclude the BLOBS. I know I can use oncheck to do this but a nice sleek bit of SQL would be preferable. If you can tell me the name of the table that contains information on blob usage per table that would be great. Regards Andy G. _________________________________________________________________ Use Hotmail to send and receive mail from your different email accounts. http://clk.atdmt.com/UKM/go/167688463/direct/01/

The only way that I am aware of that you can get the size of Simple or Smart Large Objects that are not being stored 'in table' is to: SELECT sum(length(my_blob_col)) FROM my_blob_table; This is not tracked in the system catalog nor in the SMI tables in sysmaster. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Oct 6, 2009 at 6:31 AM, Andrew Grantham <agrantha@hotmail.com>wrote: > All, > > I would like to devise a way of determining the table size of a table using > the sysmaster database preferably but I don´t mind another place as long as > it > uses SQL. > > By table size I mean the inclusion of BLOB pages, index pages etc etc. I > have > looked at sysextents, systabextents and some others and they seem to > exclude > the BLOBS. I know I can use oncheck to do this but a nice sleek bit of SQL > would be preferable. > > If you can tell me the name of the table that contains information on blob > usage per table that would be great. > > Regards > > Andy G. > > _________________________________________________________________ > Use Hotmail to send and receive mail from your different email accounts. > http://clk.atdmt.com/UKM/go/167688463/direct/01/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747b76e517049047541d56d