|
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
.jpg)
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: 19244
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: 10873
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: 1788
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 |
|
|
|
|
