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

A single query for deciding to run REORG


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srilata83

New User


Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Tue Jul 26, 2011 4:23 pm
Reply with quote

Hi,
I am trying to run a single query to get the values of some parameter which helps to decide whether we should REORG the tablespace or not.For that I am considering below values:
Clusterratio and Nlevels from sysibm.sysindexes, Farindref and Nearindref from sysibm.systablepart,Leafdist from sysibm.sysindexpart

Can anyone provide me the single query to get all these values together?


Thanks a lot in advance ...

Regards,
Srilata
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Jul 26, 2011 4:31 pm
Reply with quote

a simple google search lead here
ibmmainframes.com/about51117.html

not the final solution, but quite a few suggestions on how to proceed

meditate on dsnaccor and dsnaccox
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 Reorg abended with REASON=X'00E40347' DB2 2
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts How to append a PS file into multiple... JCL & VSAM 3
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top