View previous topic :: View next topic
|
Author |
Message |
rockish
Active User
Joined: 05 Jun 2009 Posts: 185 Location: Planet Earth
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
rockish,
If you have real time statistics ON. You can check the table SYSIBM.SYSTABLESPACESTATS and columns REORGLASTTIME, STATSLASTTIME.
Sushanth |
|
Back to top |
|
|
tamal_babu
New User
Joined: 06 Feb 2006 Posts: 17 Location: Kolkata
|
|
|
|
TABLE : SYSIBM.SYSTABLES
REORG TIME COLUM : STATSTIME |
|
Back to top |
|
|
tamal_babu
New User
Joined: 06 Feb 2006 Posts: 17 Location: Kolkata
|
|
|
|
SELECT
REORGLASTTIME
STATSLASTTIME
FROM "SYSIBM".TABLESPACESTATS |
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
Hi tamal babu,
I dont think repeating the same answers would help anybody in anyway
|
|
Back to top |
|
|
tamal_babu
New User
Joined: 06 Feb 2006 Posts: 17 Location: Kolkata
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
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 |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
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 |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10888 Location: italy
|
|
|
|
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 |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
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 |
|
|
rockish
Active User
Joined: 05 Jun 2009 Posts: 185 Location: Planet Earth
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
|