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
>
>



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