How to find out when RUNSTATS & Re-org was executed last

chinnielr · New User Joined: 11 Jul 2005 Posts: 87

Hi,

Can you please let me know when the RUNSTATS & ReORG was executed last time.

Regards,
Kiran.

GuyC · Posted: Mon May 31, 2010 2:55 pm

They were executed yesterday.

V9 : check out SYSIBM.SYSTABLESPACESTATS
V8 : check out SYSIBM.TABLESPACESTATS

STATSTIME in SYSTABLES , SYSINDEXES
TIMESTAMP in SYSCOPY where TYPE in ('W','X')

Raghu navaikulam · Posted: Mon May 31, 2010 11:03 pm

Hi GuyC

Thanks

chinnielr · New User Joined: 11 Jul 2005 Posts: 87

GuyC,

When I executed the following query

select * from sysibm.tablespacestats it says "SYSIBM.TABLESPACESTATS could not be found".

Our shop uses DB2 version 8 Release 1.

Even I tried with SYSTABLESPACESTATS and it is also not found.

Regards,
Chinni.

enrico-sorichetti · Posted: Tue Jun 01, 2010 10:37 am

what about looking at the manuals for the relevant system tables names ??

GuyC · Posted: Tue Jun 01, 2010 12:58 pm

I'm pretty sure the tablenames are correct :
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.admin/rtstcrt.htm#rtstcrt

Real Time Statistics is optional in V8, so maybe it hasn't been set up in your shop.

the old-fashioned way :
runstats : STATSTIME in SYSTABLES , SYSINDEXES
reorg : TIMESTAMP in SYSCOPY where TYPE in ('W','X')

satyender · Posted: Fri Jun 04, 2010 5:12 am

chinnielr,

Herein is the query:

SELECT * FROM SYSIBM."SYSTABLESPACESTATS";

UPDATESTATSTIME
--------------------------
2009-09-03-11.27.30.270217
2009-09-03-11.27.30.270259
2009-09-03-11.27.30.270288
2009-09-03-11.27.30.270329
2009-09-03-11.27.30.270369
2009-09-03-11.27.30.274428
2009-09-03-11.27.30.274461

REORGLASTTIME
--------------------------
2009-09-03-11.06.32.071429
2009-09-03-11.06.35.526080
2009-09-03-11.06.37.119042
2009-09-03-11.06.38.800379
2009-09-03-11.06.40.284214
2009-09-03-11.07.47.618183
2009-09-03-11.07.48.842852

GuyC · Posted: Fri Jun 04, 2010 12:14 pm