Connect to the DB you want the size of and use:

db2 "call sysproc.get_dbsize_info(?,?,?,0)"

-----Original Message-----
From: Khan Nadeem
[mailto:db2udbdba-ezmlmshield-x20205835.[Email address protected]
Sent: Thursday, March 29, 2007 5:11 AM
To: LazyDBA Discussion
Subject: size of db


Gurus,



I remember there is a function to calculate size of DB

But I am unable to recollect

Can some one suggest me the same



Nadeem



This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page