Well, well, well!
It's Coffman Bart! hehe. How have you been? Not! I ran it against the old famous "SAMPLE" database and a database that I created called "EDTEST"! The other statement: call get_dbsize_info(?,?,?,-1) worked! hehe.




-----Original Message-----
From: Coffman Bart (STL)
[mailto:db2udbdba-ezmlmshield-x89849353.[Email address protected]
Sent: Wednesday, June 07, 2006 3:28 PM
To: LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...


Hey Ed! Your DB is Zero bytes!

Those kind are easier to manage! Backup and recovery is SO easy...

?;^)

J. Bart Coffman


-----Original Message-----
From: Edwards Ed [mailto:db2udbdba-ezmlmshield- Sent: Wednesday, June 07, 2006 2:23 PM
To: LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...

Hey Guillermo J. Moreno M.
When I ran your code (it is not my original I copied from someone else in this forum), my output was:

TBS_SPCE
------------
0

What's up with that? hehe.







Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Guillermo J. Moreno M.
Sent: Wednesday, June 07, 2006 2:18 PM
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: Shanmuga P Kandasamy
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






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





******* Confidentiality Notice *******
This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments.





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