468,117 Members | 2,204 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Tablespace conteiner I/O statistics

Is there a way to capture I/O statistics per tablespace container?
Or, as long as DB2 normaly stripes/rebalances data pages across
containers, the number of physical reads and/or writes from a
tablespace snapshot could just be devided by number of the
tablespace's containers to get a rough estimate?

Thanks,
-Eugene
Nov 12 '05 #1
1 1939
I don't think there is a way to do this. You cannot divide the
tablespace snapshot values by the number of containers to get a per
container value because, which containers are accessed and how
frequently ultimately depends on what data is accessed from the
database (e.g. a where clause may limit access to elements from only 2
out of 5 containers).
If your containers are on different devices, maybe an OS level IO
metric will give you some idea of how much IO is occuring on each
device.
eu****@profitlogic.com (Eugene) wrote in message news:<95**************************@posting.google. com>...
Is there a way to capture I/O statistics per tablespace container?
Or, as long as DB2 normaly stripes/rebalances data pages across
containers, the number of physical reads and/or writes from a
tablespace snapshot could just be devided by number of the
tablespace's containers to get a rough estimate?

Thanks,
-Eugene

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jens H. Hamann | last post: by
6 posts views Thread by robert | last post: by
2 posts views Thread by Raghava | last post: by
6 posts views Thread by Konstantin Andreev | last post: by
4 posts views Thread by Rahul B | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.