Hi,

Can anybody has the ready made script to find out the database size
using sum of used pages for different page sizes
from the tablespace snapshot function .

My db has 392 tablespaces with diff page sizes. I wan to know the sum of
all used pages for all these tablespaces.

Thanks,
Jayaprakash.

-----Original Message-----
From: Guillermo J. Moreno M.
[mailto:db2udbdba-ezmlmshield-x74870387.[Email address protected]
Sent: Tuesday, June 06, 2006 4:37 AM
To: LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...

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



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