Upload

Loading icon Loading...

This video is unavailable.

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

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like DB2-LUW-ACADEMY's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike DB2-LUW-ACADEMY's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add DB2-LUW-ACADEMY's video to your playlist.

Published on Jan 20, 2014

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.PACK­AGES

Happy Learning & Sharing

  • Category

  • License

    Standard YouTube License

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Loading...
Working...
to add this to Watch Later

Add to