db2pd -d dbname -tcbstats
If you are not using this handy tool, get moving! The tcbstats option displays u/d/I activity for tables since last DB2 start. Also, with the index option you can see index activity such as ixscans, page splits, # of times an index used for ixonly access and page reorgs. You can use this info to identify your most active tables and indexes and then target them for improvement along with the SQL that accesses them. That’s the view from here!