DB2 Tips n Tricks Part 49 – How to Find Size,Invalid Indexes and Rebuild Manually

How to Find Size,Invalid Indexes and Rebuild them Manually
Solution:
Use Routine SYSPROC.ADMIN_GET_INDEX_INFO()
REORG INDEXES ALL FOR TABLE STAFF ALLOW READ ACCESS REBUILD

Happy Learning & Sharing