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