IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to find Reorg/Runstats date


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 1020
Location: India

PostPosted: Tue Dec 22, 2009 9:50 am
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
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
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
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
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

Moderator Emeritus


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

PostPosted: Tue Dec 22, 2009 9:33 pm
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
Reply with quote

tamal babu
Please check your previous post too.
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

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Dec 23, 2009 11:53 am
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: 1787
Location: Bloomington, IL

PostPosted: Wed Dec 23, 2009 8:28 pm
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Date format correction using dfsort DFSORT/ICETOOL 3
No new posts Sorting Date Field DFSORT/ICETOOL 4
No new posts CONVERT a given date from UTC TO BST CICS 0
No new posts Pull data using date difference betwe... DB2 6
No new posts CA7 count with DATE variable CA Products 0
Search our Forums:

Back to Top