If you're V8, you can use the SNAPSHOT_CONTAINER table function to get the info
you're looking for:

select TABLESPACE_NAME, CONTAINER_NAME from
TABLE(SNAPSHOT_CONTAINER(CAST (NULL as VARCHAR(255)),-1)) as A

The function provides other info like total_pages, usable_pages. TABLESPACE_NAME
is a varchar(128) and CONTAINER_NAME is a varchar(256) so you may want to substr
them...


Chuck Hamilton wrote:

> Is there a table or view I can query to list the container names and the
> tablespaces they're associated with? I really don't like the format of the
> output from the LIST TABLESPACE CONTAINERS command or the limitation of only
> listing the containers for one tablespace at a time, or having to translate
> tablespace names to #'s before I can get the container names.
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: db2udbdba-[Email address protected]

--
NOTICE: If received in error, please destroy and notify sender. Sender does not
waive confidentiality or privilege, and use is prohibited.



DB2 & UDB email list listserv db2-l LazyDBA home page