Hello, I am running DB2 V9.7 ESE on AIX. The current database has the
indexes contained inside the tablespaces. For performance purposes we
are wanting to move the indexes to a separate disk space. Is there a
way to tell how much of the utilized space/pages in a table space is
taken up by our indexes?

Thanks in advanced.

On Jan 24, 2:00*pm, shorti <lbrya... (AT) juno (DOT) com> wrote:
Yes, look at the INDEX_OBJECT_P_SIZE column in
SYSIBMADM.ADMINTABINFO. This view shows the allocation on a per
table basic, but you can pretty easily join with SYSCAT.TABLES to
get the amount per tablespace.


Good luck,


Ian

On Jan 24, 4:57*pm, Ian <ianb... (AT) mobileaudio (DOT) com> wrote:
Thanks Ian....this is exactly what I was looking for!