I ran this query and noticed that there is a segmented TS that has 2 entries in SYSTABLESPACESTATS.
FROM SYSIBM.SYSTABLESPACESTATS WHERE PARTITION=0
GROUP BY DBNAME, NAME
This is the timeline of this particular Tablespace.
First created on -- 2009-08-11
First dropped on -- 2015-06-16
Again created on -- 2017-06-13
First entry in SYSTABLESPACESTATS has the UPDATESTATSTIME as
2015-06-16 126.96.36.1991640, and the 2nd entry has UPDATESTATSTIME
as today’s date (RTS externalized every 30 minutes).
I thought entries pertaining to a Tablespace will be removed from all Db2 catalog tables when a Tablespace is dropped.
Can you please help me in understanding why there are 2 entries
for this particular Tablespace?
Also, what can be the reasons for a Tablespace to have UPDATESTATSTIME < CURRENT DATE when RTS are externalized every 30 mins?