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
>
>
DB2 & UDB email list listserv db2-l LazyDBA home page