Outstanding! Have a great Day!


-----Original Message-----
From: Durgesh Mankar-GA
[mailto:db2udbdba-ezmlmshield-x96646525.[Email address protected]
Sent: Wednesday, June 07, 2006 6:44 AM
To: LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...


It's available in ver. 8.2 also !!!

-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x32158299.[Email address protected]
Sent: Wednesday, June 07, 2006 4:08 PM
To: LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...

Shanmuga P Kandasamy,
Outstanding! Thanks for the info! Have a great Day!


http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.
db2.udb.admin.doc/doc/r0011863.htm






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: Shanmuga P Kandasamy
[mailto:db2udbdba-ezmlmshield-x47308890.[Email address protected]
Sent: Wednesday, June 07, 2006 6:27 AM
To: LazyDBA Discussion
Subject: 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


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