469,299 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

DATABASECAPACITY and SMS tablespaces

So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh,
I know). I'm tight on space and keeping an eye using the
get_dbsize_info function - but the DATABASECAPACITY value keeps
changing. I know on DMS tablespaces, DATABASECAPACITY is tied to the
amount of space allocated to the tablespaces - What determines the
value of DATABASECAPCITY on purely SMS tablespaces? This is Linux, if
it matters.

Thanks,
Ember
IBM Certified Advanced Database Administrator
DB2 UDB V8.1 for LUW
Oct 23 '08 #1
2 2228
We also have SMS-only DBs (and are quite happy with it. Bad experience
with DMS!)

DATABASECAPACITY is -1 for us, because the DB can't derive the total
disk capacity.
You have to use unix/linux tools (e.g. "df") to get this information.
On Oct 23, 4:30*pm, daiesy.em...@gmail.com wrote:
So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh,
I know). I'm tight on space and keeping an eye using the
get_dbsize_info function - but the DATABASECAPACITY value keeps
changing. I know on DMS tablespaces, DATABASECAPACITY is tied to the
amount of space allocated to the tablespaces - What determines the
value of DATABASECAPCITY on purely SMS tablespaces? This is Linux, if
it matters.

Thanks,
Ember
IBM Certified Advanced Database Administrator
DB2 UDB V8.1 for LUW
Oct 24 '08 #2
The size of SMS tablespace is whatever size the tables in their files
in their container directories occupy. It will change constantly as
the actual size of the files change in the file systems holding the
containers.
For DMA the size is determined by the amount of preallocated space of
the containers. Even if empty thay will still reflect the defined size
as their size.
If you need to find the size of SMS based tbspaces then you have to
use os commands to find the space occupied in the file systems holding
your containers. Take into account the space used by lobs in their
files or tbspaces.
Regards, Pierre.

On Oct 23, 10:30*am, daiesy.em...@gmail.com wrote:
So I have a good-sized db (~500GB) that's on only SMS tablespaces(ugh,
I know). I'm tight on space and keeping an eye using the
get_dbsize_info function - but the DATABASECAPACITY value keeps
changing. I know on DMS tablespaces, DATABASECAPACITY is tied to the
amount of space allocated to the tablespaces - What determines the
value of DATABASECAPCITY on purely SMS tablespaces? This is Linux, if
it matters.

Thanks,
Ember
IBM Certified Advanced Database Administrator
DB2 UDB V8.1 for LUW
Oct 25 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CK | last post: by
8 posts views Thread by Joachim Mueller | last post: by
reply views Thread by sethwai | last post: by
10 posts views Thread by rAinDeEr | last post: by
3 posts views Thread by dcruncher4 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.