With help of below query we are getting output for all tables and indexes "db2 reorgchk current statistics on table all". But I want only those tables which we can reorg on that tables like *---*,--** etc.....
Please provide me SQL query where I can see only that tables name where they require reorgs.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!