Ed,
If you are running Windows and v8.2 fp7 I suggest to use the admin client
once you select the DB you will se the size and all the settings for a
specific DB that will be easy.
To be specific I did not use this script on windows
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
IMPORTANTE: Los documentos y archivos que se acompañan a esta transmisión,
contienen información confidencial la cual es legalmente secreta. Esta
información puede ser usada únicamente por el destinatario cuyo nombre
aparece inserto en esta transmisión. Si usted ha recibido esta transmisión
por error, notifíquenos inmediatamente por esta misma vía, y borre el
archivo y sus anexos. Se hace de su conocimiento por medio de esta nota, que
cualquier divulgación, copia, distribución o toma de cualquier acción
derivada de la información confiada en esta transmisión, queda estrictamente
prohibido, el incumplimiento de esto genera responsabilidad legal.
IMPORTANT: The documents and files attached to this transmission contain
confidential information that must be kept secret by law. This information
is for the exclusive use of the specified recipient whose name appears in
this transmission. If you have received this message by mistake, please
notify us immediately by return e-mail and delete the file and its
attachments. You are hereby notified that any dissemination, copying,
distribution or adoption of any action arising from the confidential
information contained herein is strictly prohibited. Any violation will be
penalized by law.
-----Mensaje original-----
De: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x23725945.[Email address protected]
Enviado el: Jueves, 08 de Junio de 2006 05:36 a.m.
Para: LazyDBA Discussion
Asunto: RE: DB2 database size and tablespace size ...
Moreno,
I am running DB2 version 8.2, Fixpack 7 for Windows; and I still get zero.
-----Original Message-----
From: Guillermo J. Moreno M.
[mailto:db2udbdba-ezmlmshield-x76429661.[Email address protected]
Sent: Wednesday, June 07, 2006 6:02 PM
To: LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...
Ed,
Look what i got from one of my DB's I'm working on v8.1 Fix pck 6
db2 => connect to BDDFN004
Database Connection Information
Database server = DB2/SUN64 8.1.6
SQL authorization ID = FDM81D
Local database alias = BDDFN004
db2 => select (sum(total_pages)* 4096)/(1024*1024) Tot_allocat_spce from
table(snapshot_tbs_cfg('',-1)) TBS_SPCE
TOT_ALLOCAT_SPCE
--------------------
130788
1 record(s) selected.
That's means I have a DB with a total of 130 GB in size and this is one of
the shortest
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
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
IMPORTANTE: Los documentos y archivos que se acompañan a esta transmisión,
contienen información confidencial la cual es legalmente secreta. Esta
información puede ser usada únicamente por el destinatario cuyo nombre
aparece inserto en esta transmisión. Si usted ha recibido esta transmisión
por error, notifíquenos inmediatamente por esta misma vía, y borre el
archivo y sus anexos. Se hace de su conocimiento por medio de esta nota, que
cualquier divulgación, copia, distribución o toma de cualquier acción
derivada de la información confiada en esta transmisión, queda estrictamente
prohibido, el incumplimiento de esto genera responsabilidad legal.
IMPORTANT: The documents and files attached to this transmission contain
confidential information that must be kept secret by law. This information
is for the exclusive use of the specified recipient whose name appears in
this transmission. If you have received this message by mistake, please
notify us immediately by return e-mail and delete the file and its
attachments. You are hereby notified that any dissemination, copying,
distribution or adoption of any action arising from the confidential
information contained herein is strictly prohibited. Any violation will be
penalized by law.
-----Mensaje original-----
De: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x17577308.[Email address protected]
Enviado el: Miércoles, 07 de Junio de 2006 02:23 p.m.
Para: LazyDBA Discussion
Asunto: 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.
[mailto:db2udbdba-ezmlmshield-x37808418.[Email address protected]
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
[mailto:db2udbdba-ezmlmshield-x47308890.[Email address protected]
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
"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
---------------------------------------------------------------------
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