Hey Ed,
This command only Works for DB2 UDB 8.1 fix pack 11 and up if you happens to
have previous version you do not get this stored procedure, and many many
times you will be ending with previous versions on your assignment.
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: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x2227146.[Email address protected]
Enviado el: Miércoles, 07 de Junio de 2006 02:33 p.m.
Para: LazyDBA Discussion
Asunto: RE: DB2 database size and tablespace size ...
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
---------------------------------------------------------------------
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