Dang! I forgot to add...did you check your db2diag.log file and your new
admin log file for any errors? That is step #1 with UDB.
Verify that your diaglevel is set properly to feed you messages.
J. Bart Coffman
-----Original Message-----
From: Coffman, Bart (STL)
Sent: Thursday, June 08, 2006 10:20 AM
To: 'Edwards Ed '; LazyDBA Discussion
Subject: RE: DB2 database size and tablespace size ...
OK, Ed, I am grasping at air here, but if you do the following, you may
learn something about this database...
Are all your monitor switches turned ON?
Do you have sysadm auth for this instance?
Can you get the query to run successfully on any other db? Or is it
just this one rascal?
Have you run runstats against your tables? I don't think this would
make the diff, but bears checking.
Have you backed up your db since creating it? And once you get a backup
image, run db2chkbkp against it.
You could run db2dart or inspect command to see if something is wrong.
Are all your tablespace states normal? (db2 list tablespaces)
J. Bart Coffman
-----Original Message-----
From: Edwards Ed [mailto:db2udbdba-ezmlmshield- Sent: Thursday, June 08,
2006 5:36 AM
To: LazyDBA Discussion
Subject: 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.
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]
S o f t t e k
Atentamente
Guillermo J. Moreno M.
GDC IMSS SASA - PREI - DB2 SUPPORT and STAFF
guillermo.[Email address protected]
-----Mensaje original-----
De: Edwards Ed
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.
-----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]
S o f t t e k
-----Mensaje original-----
De: Shanmuga P Kandasamy
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.
DB2 & UDB email list listserv db2-l LazyDBA home page