Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to check when the last RUNSTATS was done?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Thu Nov 16, 2006 10:52 pm    Post subject: How to check when the last RUNSTATS was done?
Reply with quote

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
Back to top
View user's profile Send private message

MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Fri Nov 17, 2006 1:10 am    Post subject: Re: How to check when the last RUNSTATS was done?
Reply with quote

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'                                             
Back to top
View user's profile Send private message
vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Fri Nov 17, 2006 3:51 am    Post subject: Re: How to check when the last RUNSTATS was done?
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. GDG gen check using REXX raghuraman123 CLIST & REXX 6 Wed Apr 18, 2018 9:18 pm
No new posts How syntax check at Bind time is diff... Poha Eater DB2 5 Wed Mar 21, 2018 9:16 pm
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us