Hi,
How to check Indexes which need to be REORG on database?

Any SQL query to indentify all indexes of database which need to de-fragment?

How to do auto schedule of REORG de-fragment indexes daily?

Thanks

reorgchk gives information about tables-indexes
there are some sysibmadm views that generate similar info as reorgchk
table maintenance can be activated for stats-reorg

Can you please give reference related sysibmadm views to check?

all info is in the doc (created for this purpose)
IBM DB2 9.7 for Linux, UNIX and Windows Information Center