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
 

 

A single query for deciding to run REORG

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: A single query for deciding to run REORG
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Tue Jul 26, 2011 4:31 pm    Post subject: Reply to: A single query for deciding to run REORG
Reply with quote

a simple google search lead here
http://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    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 Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm


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