One of my favorite administrative views in DB2 LUW is SYSIBMADM.SNAPDB. It provides basic stats at the database level - including my very favorite ROWS_READ. When the users claim that the database is running slow and the queries are taking longer, I always take a quick look at the rows read to see if I…
Read more
The Power of SYSIBMADM.SNAPDB
