To find the size in bytes you can multiply the number of pages in a table by the pagesize for the tablespace:

select tab.npages * ts.pagesize as bytes from
syscat.tables tab, syscat.tablespaces ts
where tab.tabname = 'INSERTTABNAMEHERE'
and tab.tbspace=ts.tbspace
;

Charlie Crissman

-----Original Message-----
From: thirumaran
[mailto:db2udbdba-ezmlmshield-x27046986.[Email address protected]
Sent: Friday, September 24, 2004 2:09 AM
To: LazyDBA Discussion
Subject: Re: Table Sizes !!!


Hi chandrasekar


You can use control center to find the size estimate of tables and no of
rows in a table.

pl select & run runstats before you use this .


Thanks

Thirumaran
----- Original Message -----
From: "thirumaran "
<db2udbdba-ezmlmshield-x14488561.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, September 24, 2004 11:21 AM
Subject: Re: Table Sizes !!!


> Hi chandrasekar
>
> Estimation Formulae:
>
> #A.
> 1) Table Space Size = (average row size + 8) * no of rows * 1.5
> 2) Index Space Size = (average index key size + 8) * no of rows * 2
> 3) Temp Space Size = (average index key size + 8) * no of rows * 3.2
>
>
>
>
> Thanks
>
> Thirumaran
> ----- Original Message -----
> From: "Chandrasekar"
> <db2udbdba-ezmlmshield-x74678774.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Friday, September 24, 2004 10:33 AM
> Subject: Table Sizes !!!
>
>
> >
> > Hi All,
> >
> > How do i find the Individual Table Sizes in DB2 and Number of Records
> in a Table. Is there any command readily available.
> >
> > Thanks
> >
> > Chandra
> > ========
> > ----------------------------------------- (on scbaprssxmrl)
> >
> > This email is confidential. If you are not the addressee tell the sender
> immediately and destroy this email without using, sending or storing it.
> Emails are not secure and may suffer errors, viruses, delay, interception
> and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not
> accept liability for damage caused by this email and may monitor email
> traffic. Unless expressly stated, any opinions are the sender's and are
not
> approved by SCGroup and this email is not an offer, solicitation,
> recommendation or agreement of any kind.
> >
> >
> >
> > Standard Chartered Bank ("SCB") is a member of SCGroup incorporated in
> England with limited liability. SCB's principal office is 1 Aldermanbury
> Square, London, EC2V 7SB, UK. SCB is authorised and regulated by the
> Financial Services Authority ("FSA") and in FSA's register under no.
114276.
> SCB's VAT no. is GB244106593. FSA is the lead regulator for the SCGroup.
For
> regulators in other countries contact the local compliance officer.
> >
> > ---------------------------------------------------------
> >
> >
> > ---------------------------------------------------------------------
> > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> > website: http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc. The information contained in this document may be confidential and intended solely for the use of the individual or entity to whom it is addressed. This document may contain material that is privileged or protected from disclosure under applicable law. If you are not the intended recipient or the individual responsible for delivering to the intended recipient, please (1) be advised that any use, dissemination, forwarding, or copying of this document IS STRICTLY PROHIBITED; and (2) notify sender immediately by telephone and destroy the document. THANK YOU.



DB2 & UDB email list listserv db2-l LazyDBA home page