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: 10201
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: 1738
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: 1278
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 How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm
No new posts Find out a active PGM jpsager JCL & VSAM 10 Fri Oct 07, 2016 4:32 pm


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