also you can use from v8.2 onwards db2pd -db <dbname> -tablespaces


Gert van der Kooij wrote:
> In article <eom9mj$40m$1@news.net.uni-c.dk>, troels@arvin.dk says...
> > Hello,
> >
> > I need to get an overview of all my tablespaces, how full they are, and
> > which containers are connected to them.
> >
> > I know of LIST TABLESPACE CONTAINERS, but it's annoying to have to look up
> > the tablespace ID before LIST TABLESPACE CONTAINERS can be used. And LIST
> > TABLESPACE CONTAINERS doesn't seem to be universally available (e.g., it
> > seems that db2batch doesn't support it).
> >
> > So:
> > Is there a way to use SQL to find containers allocated to tablespaces? -
> > I'm thinking about some kind of system table/view, alike
> > SYSIBM.SYSTABLESPACES. - That way I could join between SYSTABLESPACES and
> > other relevant tables to get my full list.
> >
>
> Using DB2 V9 you can use the CONTAINER_UTILIZATION administrative view
> to get this info, it's documented at http://tinyurl.com/2x2zwq.