469,336 Members | 5,442 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

Question 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

Feb 3 '06 #1
3 1188
Ian
da*******@yahoo.com wrote:
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?


db2 update monitor switches using table on
db2 "get snapshot for tables on <yourdb>"
Feb 3 '06 #2
Ian wrote:
da*******@yahoo.com wrote:
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?

db2 update monitor switches using table on
db2 "get snapshot for tables on <yourdb>"

... also take a look at db2pd

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Feb 3 '06 #3
Thanks much.

Feb 6 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Kayra Otaner | last post: by
6 posts views Thread by Tim | last post: by
4 posts views Thread by Alexander Pope | last post: by
8 posts views Thread by John Lee | last post: by
13 posts views Thread by Chris | last post: by
4 posts views Thread by Darren | last post: by
17 posts views Thread by (PeteCresswell) | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.