Hello there,

You may use the follow (it is not my original I copied from someone else in
this forum)

DB size in MB:
select (sum(total_pages)* 4096)/(1024*1024) Tot_allocat_spce from
table(snapshot_tbs_cfg('',-1)) TBS_SPCE

That will give you the DB size in MB
Works great


Atentamente

Guillermo J. Moreno M.
GDC IMSS SASA - PREI - DB2 SUPPORT and STAFF

guillermo.[Email address protected]

04455-5506-0558

S o f t t e k


-----Mensaje original-----
De: akhileshmittal
[mailto:db2udbdba-ezmlmshield-x64428220.[Email address protected]
Enviado el: Lunes, 05 de Junio de 2006 05:25 p.m.
Para: LazyDBA Discussion
Asunto: Re: DB2 database size and tablespace size ...

If you are 8.1 or above use snapshot table function

select * from table(snapshot_tbs_cfg('HEWD03',-1)) as A

--Akhilesh



"benbart" <db2udbdba-ezmlmshield-x5880328.[Email address protected]
05/06/2006 03:05 PM
Mail Size: 4168

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
DB2 database size and tablespace size ...
Our Ref

Your Ref







Hi all,

Am very new to DB2 so forgive me if I ask some very easy questions?

Anyway, is there a single command that I can run to show the size of my
database? At the moment, am doing list tablespaces show detail and then
adding
up Total Pages x Page Size and using the grand sum as the database size,
am I
doing it correctly this way?

Any advise will be very much appreciated .... thanks ...






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


-----------------------------------------
******************************************************************
This message originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************




-----------------------------------------
*******************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.

Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
*******************************************************************
"SAVE PAPER - THINK BEFORE YOU PRINT!"


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