vijikesavan
Active User
Joined: 04 Oct 2006 Posts: 118 Location: NJ, USA
|
|
|
|
Hi all,
I have to check if runstats was run on a table for a particular date?
Which table I should be searching? which column to look..
pls help.
Thanks,
Viji |
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
Query SYSIBM.SYSINDEXES and review column STATSTIME.
Code: |
SELECT "NAME", CREATOR, TBNAME, TBCREATOR -- "SYSIBM".SYSINDEXES
, UNIQUERULE, COLCOUNT, CLUSTERING -- "SYSIBM".SYSINDEXES
, CLUSTERED, DBID, "OBID", "ISOBID" -- "SYSIBM".SYSINDEXES
, DBNAME, INDEXSPACE, FIRSTKEYCARD -- "SYSIBM".SYSINDEXES
, FULLKEYCARD, NLEAF, NLEVELS, BPOOL -- "SYSIBM".SYSINDEXES
, PGSIZE, ERASERULE, DSETPASS -- "SYSIBM".SYSINDEXES
, CLOSERULE, SPACE, IBMREQD -- "SYSIBM".SYSINDEXES
, CLUSTERRATIO, CREATEDBY, IOFACTOR -- "SYSIBM".SYSINDEXES
, PREFETCHFACTOR, STATSTIME, INDEXTYPE -- "SYSIBM".SYSINDEXES
, FIRSTKEYCARDF, FULLKEYCARDF -- "SYSIBM".SYSINDEXES
, CREATEDTS, ALTEREDTS, "PIECESIZE" -- "SYSIBM".SYSINDEXES
, COPY, COPYLRSN, CLUSTERRATIOF, SPACEF -- "SYSIBM".SYSINDEXES
, REMARKS -- "SYSIBM".SYSINDEXES
FROM "SYSIBM".SYSINDEXES
WHERE TBNAME = 'TBL NAME'
|
|
|
vijikesavan
Active User
Joined: 04 Oct 2006 Posts: 118 Location: NJ, USA
|
|
|
|
Hey thanks,
I also got the details from the table SYSIBM.TABLESPACESTATS
in the columns:
columns REORGLASTTIME and STATSLASTTIME - for reorg and runstats.
Thanks,
Viji |
|