DB2 Tips n Tricks Part 25 – How to Find unused tables,indexes or stored procedures in the Database



DB2 Tips n Tricks Part 25 – How to Find unused tables,indexes or stored procedures in the Database

DB2 Tips n Tricks Part 25 - How to Find unused tables,indexes or stored procedures in the Database

How to Find unused tables,indexes or stored procedures in the Database.
When it was last accessed?
Solution:
LASTUSED Column in SYSCAT.TABLES,SYSCAT.INDEXES,SYSCAT.PACKAGES

Happy Learning & Sharing

Comments are closed.