Ignoring the LOB issue (ie it doesn't take into account lobs) a perhaps
more robust query would be:
select tab.tbspace, tabname, npages, pagesize, (npages * 1.0 *
pagesize)/1024/1024 "Mb"
from syscat.TABLES tab,
syscat.tablespaces ts
where ts.tbspace = tab.tbspace
and tbname = '<put your table name here>'
Just in case you have some non-4k tablespaces
"John Furlong " <db2udbdba-ezmlmshield-x15087020.[Email address protected]
22/02/2008 02:28 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: table size
That is a very useful query, thank you. How accurate are the results of
the query? Are there any dependencies, such as the last time stats were
collected on the table?
-----Original Message-----
From: vishnuvardan
[mailto:db2udbdba-ezmlmshield-x80598334.[Email address protected]
Sent: Wednesday, February 20, 2008 6:24 AM
To: LazyDBA Discussion
Subject: RE: table size
Use this,
db2 "select char(TABNAME,30),TBSPACEID,((NPAGES*4)/(1024)) as
size_mbytes,FPAGES from syscat.tables where tbspace='TABSPACE_NAME'"
Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
>*:vishnuvardan.[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x33159192.[Email address protected]
Sent: Wednesday, February 20, 2008 4:45 PM
To: LazyDBA Discussion
Subject: table size
Hi DBAs,
How can I find out a particular table how much space
contain ?
Thanks
Disclaimer: This communication is for the exclusive use of the
intended recipient(s) and shall not attach any liability on the
originator or ITC Infotech India Ltd./its Holding company/ its
Subsidiaries/ its Group Companies. If you are the addressee, the
contents of this e-mail are intended for your use only and it shall not
be forwarded to any third party, without first obtaining written
authorization from the originator or ITC Infotech India Ltd./ its
Holding company/its Subsidiaries/ its Group Companies. It may contain
information which is confidential and legally privileged and the same
shall not be used or dealt with by any third party in any manner
whatsoever without the specific consent of ITC Infotech India Ltd./
its Holding company/ its Subsidiaries/ its Group Companies.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message and any attachments
to this message are intended for the exclusive use of the addressee(s)
and may contain proprietary, confidential or privileged information. If
you are not the intended recipient, you should not disseminate,
distribute or copy this e-mail. Please notify the sender immediately and
destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.
www.wipro.com
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************************
The information contained in or attached to this message is intended only for the people it is addressed to. If you are not the intended recipient, any use, disclosure or copying of this information is unauthorised and prohibited. This information may be confidential or subject to legal privilege.
It is not the expressed view of Medibank Private Limited or any of its subsidiaries unless it is authorised by a person with actual authority.
To the fullest extent allowed by law, Medibank Private cannot accept liability for any virus damage caused by this message.
Medibank Private Limited ABN 47 080 890 259.
***********************************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page