srilata83
New User
Joined: 02 Apr 2009 Posts: 16 Location: chennai
|
|
|
|
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 |
|