SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 11:29 AM
| ||||
| ||||
 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      |
|
02-27-2008, 11:29 AM
| |||
| |||
| Re: Looking up containers 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. |
|
02-27-2008, 11:29 AM
| |||
| |||
| Re: Looking up containers 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. |
|
02-27-2008, 11:30 AM
| ||||
| ||||
| Re: Looking up containers 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 |
Linear Mode
