Is there a view to return path of tablespace

[Rudolf Bargholz]

Hi,

There is a syscat.TABLESPACES view that contains data about the available
tablespaces of a database instance. What I would like to have a look at is,
the container paths where the tablespaces are stored. Is there a view that I
can use to get at the path data?

CREATE USER TEMPORARY TABLESPACE
UTPS4
PAGESIZE 4 K
MANAGED BY SYSTEM
USING ('C:\db2\tsp\utsp4')
EXTENTSIZE 32
OVERHEAD 24.1
PREFETCHSIZE 32
TRANSFERRATE 0.9
BUFFERPOOL IBMDEFAULTBP
COMMENT ON TABLESPACE UTPS4 IS ''

What I would like to determine is the 'C:\db2\tsp\utsp4' above.

I am aware that there is the

db2 LIST TABLESPACES CONTAINERS for x

which can be executed from command line, but this is a hassle to use as I
would have to write the result to a file, read the data from file and then
parse the result string to find out where the path of each container is.
There is the language issue to keep in mind (we have customers that use
different language versions of DB2 Version 7.1/7.2 on Windows and Linux
platforms) and I have to keep in mind that the output of the command might
change in future versions, so a view would make my life a little easier.

Regards

Rudolf Bargholz

[Ian]

Rudolf Bargholz wrote:

Hi,

There is a syscat.TABLESPACES view that contains data about the available
tablespaces of a database instance. What I would like to have a look at is,
the container paths where the tablespaces are stored. Is there a view that I
can use to get at the path data?

In V8, see the SNAPSHOT_CONTAINER() table function.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----