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: Shanmuga P Kandasamy
[mailto:db2udbdba-ezmlmshield-x47308890.[Email address protected]
Enviado el: Miércoles, 07 de Junio de 2006 05:27 a.m.
Para: LazyDBA Discussion
Asunto: Re: DB2 database size and tablespace size ...

Try,


call get_dbsize_info(?,?,?,-1)


Thanks & Regards,
Priya





"benbart" <db2udbdba-ezmlmshield-x5880328.[Email address protected]
06/06/2006 03:35

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

Subject
DB2 database size and tablespace size ...






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




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