470,619 Members | 1,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Looking up containers

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.

--
Regards,
Troels Arvin
Jan 17 '07 #1
3 1742
In article <eo**********@news.net.uni-c.dk>, tr****@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.
Jan 18 '07 #2
also you can use from v8.2 onwards db2pd -db <dbname-tablespaces
Gert van der Kooij wrote:
In article <eo**********@news.net.uni-c.dk>, tr****@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.
Jan 18 '07 #3
Hi, take a look at
http://www-128.ibm.com/developerwork...now/index.html
appendix 2 Tablespace container information script, this will give you
some clues ...

/Roger

Jan 18 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Dylan | last post: by
9 posts views Thread by JustSomeGuy | last post: by
14 posts views Thread by phil_gg04 | last post: by
18 posts views Thread by Matthias Kaeppler | last post: by
8 posts views Thread by Gregory | last post: by
2 posts views Thread by bob | last post: by
1 post views Thread by Jean-Marc Blaise | last post: by
15 posts views Thread by Nindi73 | last post: by
11 posts views Thread by jimxoch | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.