 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / February 2006Question on determining heavy hit tables.
Running DB2 8.1.1 on AIX 5.1 We are trying to determine heavy hit tables for tuning purposes. We have been able to extract information concerning the numbers of inserts, deletes and updates for each table. However we can't seem to determine select (read) activity for these tables. Is there a way we can determine read activity against the tables? Thanks in advance. Gerry > Running DB2 8.1.1 on AIX 5.1 > [quoted text clipped - 6 lines] > > Is there a way we can determine read activity against the tables? db2 update monitor switches using table on db2 "get snapshot for tables on <yourdb>" >> Running DB2 8.1.1 on AIX 5.1 >> [quoted text clipped - 9 lines] > db2 update monitor switches using table on > db2 "get snapshot for tables on <yourdb>" .. also take a look at db2pd Cheers Serge  SignatureSerge Rielau DB2 Solutions Development DB2 UDB for Linux, Unix, Windows IBM Toronto Lab Thanks much. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.