On zos db2, a runstats is needed to update the counts. Doesn't luw work
that way too ?
darrin
-----Original Message-----
From: Henry-Sewell Brenda
[mailto:db2udbdba-ezmlmshield-x39850783.[Email address protected]
Sent: Thursday, May 22, 2008 11:37 AM
To: LazyDBA Discussion
Subject: Tablespace - Used Pages
Hi,
When I do a list tablespace show detail for this tablespace I see the
following:
--**********************************************************************
*****
Tablespace ID = 6
Name = DYNDATA1_IDX
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 5120000
Useable pages = 5119984
Used pages = 4244656
Free pages = 875328
High water mark (pages) = 4244656
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 64
Number of containers = 1
--**********************************************************************
****
As you can see from this, I have 4,244,656 used pages.
This tablespace is used to store indexes only and I wanted to know which
indexes were using up all of this space, so I ran a query against the
syscat.indexes, and I sum the nleaf column and the num_empty_leafs
(shown below) you can see that they don't match at all what I am seeing
above, to the tune of about 600,000 PAGEs.
db2 "select SUM(nleaf) AS SUM_NLEAF from syscat.indexes where tbspaceid
= 6"
SUM_NLEAF
-----------
3678831
db2 "select SUM(num_empty_leafs) AS SUM_EMPTY_LEAFS from syscat.indexes
where tbspaceid = 6"
SUM_EMPTY_LEAFS
--------------------
3016
How do I find out what that other space is used for? I thought maybe it
was freespace but my tablespace usage is growing daily and the freespace
is still there. The tablespace has an extentsize of 16.
Any information you could give me would be greatly appreciated.
Brenda
---------------------------------------------------------------------
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