Skip to content

db2pd -d dbname -tcbstats

March 6, 2013

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!

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: