Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 
How to find Reorg/Runstats date

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

Active User


Joined: 05 Jun 2009
Posts: 185
Location: Planet Earth

PostPosted: Tue Dec 22, 2009 1:36 am    Post subject: How to find Reorg/Runstats date
Reply with quote

Hello all,

I would like to know to how to find the date of last ReOrg/RunStats performed on any specific table/tablespace in DB2 v8. Can anyone help me in finding it out pls ?
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Dec 22, 2009 9:50 am    Post subject:
Reply with quote

rockish,

If you have real time statistics ON. You can check the table SYSIBM.SYSTABLESPACESTATS and columns REORGLASTTIME, STATSLASTTIME.

Sushanth
Back to top
View user's profile Send private message
tamal_babu

New User


Joined: 06 Feb 2006
Posts: 17
Location: Kolkata

PostPosted: Tue Dec 22, 2009 12:37 pm    Post subject: Reply to: How to find Reorg/Runstats date
Reply with quote

TABLE : SYSIBM.SYSTABLES
REORG TIME COLUM : STATSTIME
Back to top
View user's profile Send private message
tamal_babu

New User


Joined: 06 Feb 2006
Posts: 17
Location: Kolkata

PostPosted: Tue Dec 22, 2009 12:42 pm    Post subject: Reply to: How to find Reorg/Runstats date
Reply with quote

SELECT
REORGLASTTIME
STATSLASTTIME
FROM "SYSIBM".TABLESPACESTATS
Back to top
View user's profile Send private message
bhairon singh rathore

New User


Joined: 19 Jun 2008
Posts: 91
Location: banglore

PostPosted: Tue Dec 22, 2009 2:54 pm    Post subject:
Reply with quote

Hi tamal babu,

I dont think repeating the same answers would help anybody in anyway
icon_evil.gif icon_cool.gif
Back to top
View user's profile Send private message
tamal_babu

New User


Joined: 06 Feb 2006
Posts: 17
Location: Kolkata

PostPosted: Tue Dec 22, 2009 6:55 pm    Post subject: Reply to: How to find Reorg/Runstats date
Reply with quote

hey bhairon Singh,
I think u dont have eyes to make the diff in the name of the catalog tables being mentioned in my posts and the earlier post...I dont think u hv any concept of catalog tables at all...first clear your concepts and then make comments..
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Dec 22, 2009 9:33 pm    Post subject: Reply to: How to find Reorg/Runstats date
Reply with quote

Hello,

Quote:
I dont think repeating the same answers would help anybody in anyway

Quote:
first clear your concepts and then make comments..
Seemed pretty clear to me. . .

Your posts were repeats of what Susanth posted. . .

There was some reason for the repitition. . .?

d
Back to top
View user's profile Send private message
bhairon singh rathore

New User


Joined: 19 Jun 2008
Posts: 91
Location: banglore

PostPosted: Wed Dec 23, 2009 11:46 am    Post subject:
Reply with quote

tamal babu
Please check your previous post too.
http://ibmmainframes.com/viewtopic.php?t=45832

It was just a suggestion...you can repeat the answer any number of times ....till other members are ok with it.

Motive behind this activity is not clear icon_biggrin.gif icon_biggrin.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10293
Location: italy

PostPosted: Wed Dec 23, 2009 11:53 am    Post subject: Re: Reply to: How to find Reorg/Runstats date
Reply with quote

sushanth bobby wrote:
rockish,

If you have real time statistics ON. You can check the table SYSIBM.SYSTABLESPACESTATS and columns REORGLASTTIME, STATSLASTTIME.

Sushanth

tamal_babu wrote:
SELECT
REORGLASTTIME
STATSLASTTIME
FROM "SYSIBM".TABLESPACESTATS


seem the same thing to me, so after all we have eyes to see icon_evil.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1772
Location: Bloomington, IL

PostPosted: Wed Dec 23, 2009 8:28 pm    Post subject:
Reply with quote

Well, no; it appears that Tamal is referring to a shadow table, not the live one (notice that Sushanth refers to SYSTABLESPACESTATS, whilst Tamal refers to TABLESPACESTATS -- no SYS). I am not altogether clear on the usage (I'm not a DBA, don't play one on TV, and didn't even stay at a Holiday Inn last night), but I believe that the shadow table is periodically LOAD RESUMEd from the live one, with a timestamp added to the rows, to provide history. The shadow table may actually be a better choice in this case (if it exists -- it's a site-specific add-on, methinks), as it is more likely to contain historical information.

Use of shadow and live tables is discussed here.
Back to top
View user's profile Send private message
rockish

Active User


Joined: 05 Jun 2009
Posts: 185
Location: Planet Earth

PostPosted: Fri Dec 25, 2009 12:19 am    Post subject:
Reply with quote

Thank you all for your replies.

I really do not know what happened and I dint get a single mail notifying reply for my post !!!! And hence I am checking it so much late..
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon Dec 28, 2009 7:52 pm    Post subject:
Reply with quote

in V8 it is optional and called tablespacestats (although a smart DBA might create aliasses called systablespacestats)
in V9 it is moved into the catalog an renamed to systablespacestats
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
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us