How to find a tablespace storage size and containers size via system tables

[aaronk321]

I'm cloning a db and I need to redirect the files using the set
tablespace container command. However, that command requires the size
of the tablepsace - I've developed the following sql which will get my
tablspace names - where would I find the tablespace size for the
tablespaces I want to clone.

select 'set tablespace containers for '
|| rtrim(char(tbspaceid))
|| case tbspacetype when 'S' then ' using (path '||''''
||'/db2_test/epmtst01/data/'||tbspace||''''||');'
when 'D' then ' using (file ' ||''''
||'db2_test/epmtst01/data/'||tbspace||'.DBF '||
rtrim(char(pagesize))||''''||');'
end
from syscat.tablespace

It would output..

set tablespace containers for 237 using file
'(db2_test/epmtst01/data/WAWORKIDX.DBF)'

However, I need to add the number of pages at the end of that
statement.

thanks

[Mark A]

<aa*******@yahoo.com> wrote in message
news:6f**************************@posting.google.c om...

I'm cloning a db and I need to redirect the files using the set
tablespace container command. However, that command requires the size
of the tablepsace - I've developed the following sql which will get my
tablspace names - where would I find the tablespace size for the
tablespaces I want to clone.

select 'set tablespace containers for '
|| rtrim(char(tbspaceid))
|| case tbspacetype when 'S' then ' using (path '||''''
||'/db2_test/epmtst01/data/'||tbspace||''''||');'
when 'D' then ' using (file ' ||''''
||'db2_test/epmtst01/data/'||tbspace||'.DBF '||
rtrim(char(pagesize))||''''||');'
end
from syscat.tablespace

It would output..

set tablespace containers for 237 using file
'(db2_test/epmtst01/data/WAWORKIDX.DBF)'

However, I need to add the number of pages at the end of that
statement.

thanks

list tablespaces show detail

There is way in Version 8 to access this via SQL if you check out the
following article
www-106.ibm.com/developerworks/db2/library/techarticle/dm-0404snow/index.htm
l
see Appendix 1: Table Space Information Script

[Mark A]

<aa*******@yahoo.com> wrote in message
news:6f**************************@posting.google.c om...

I'm cloning a db and I need to redirect the files using the set
tablespace container command. However, that command requires the size
of the tablepsace - I've developed the following sql which will get my
tablspace names - where would I find the tablespace size for the
tablespaces I want to clone.

select 'set tablespace containers for '
|| rtrim(char(tbspaceid))
|| case tbspacetype when 'S' then ' using (path '||''''
||'/db2_test/epmtst01/data/'||tbspace||''''||');'
when 'D' then ' using (file ' ||''''
||'db2_test/epmtst01/data/'||tbspace||'.DBF '||
rtrim(char(pagesize))||''''||');'
end
from syscat.tablespace

It would output..

set tablespace containers for 237 using file
'(db2_test/epmtst01/data/WAWORKIDX.DBF)'

However, I need to add the number of pages at the end of that
statement.

thanks

list tablespaces show detail

There is way in Version 8 to access this via SQL if you check out the
following article
www-106.ibm.com/developerworks/db2/library/techarticle/dm-0404snow/index.htm
l
see Appendix 1: Table Space Information Script

[Mark A]

http://www-106.ibm.com/developerwork...now/index.html

[Mark A]

http://www-106.ibm.com/developerwork...now/index.html