By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

On what parameter does Database Capacity depend

P: n/a
Hi,

I wanted to know on which parameters does database capacity depend on?
Is it only dependent on the tablespaces size that i have allocated?
I am getting the following.

C:\Program Files\IBM\SQLLIB\BIN>db2 call get_dbsize_info(?, ?, ?, 0)

Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2007-09-13-00.21.25.978868

Parameter Name : DATABASESIZE
Parameter Value : 40445849600

Parameter Name : DATABASECAPACITY
Parameter Value : 50768454132

Return Status = 0
Currently, the diff is around 10 GB and i have to create some more
schemas which might reduce the difference even further.

Will the database capacity be resolved and database capacity increased
if i extend the tablespaces?

Thanks a lot

Rahul

Sep 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sep 12, 8:13 am, Rahul Babbar <rahul.babb...@gmail.comwrote:
Hi,

I wanted to know on which parameters does database capacity depend on?
Is it only dependent on the tablespaces size that i have allocated?
I am getting the following.

C:\Program Files\IBM\SQLLIB\BIN>db2 call get_dbsize_info(?, ?, ?, 0)

Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2007-09-13-00.21.25.978868

Parameter Name : DATABASESIZE
Parameter Value : 40445849600

Parameter Name : DATABASECAPACITY
Parameter Value : 50768454132

Return Status = 0

Currently, the diff is around 10 GB and i have to create some more
schemas which might reduce the difference even further.

Will the database capacity be resolved and database capacity increased
if i extend the tablespaces?

Thanks a lot

Rahul
yes , i think by increasing the tablespaces you can increase the
capacity.
you can try with a sample DB first

Sep 12 '07 #2

P: n/a
On Sep 12, 12:13 pm, Rahul Babbar <rahul.babb...@gmail.comwrote:
Hi,

I wanted to know on which parameters does database capacity depend on?
Is it only dependent on the tablespaces size that i have allocated?
I am getting the following.

C:\Program Files\IBM\SQLLIB\BIN>db2 call get_dbsize_info(?, ?, ?, 0)

Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2007-09-13-00.21.25.978868

Parameter Name : DATABASESIZE
Parameter Value : 40445849600

Parameter Name : DATABASECAPACITY
Parameter Value : 50768454132

Return Status = 0

Currently, the diff is around 10 GB and i have to create some more
schemas which might reduce the difference even further.

Will the database capacity be resolved and database capacity increased
if i extend the tablespaces?

Thanks a lot

Rahul
###
Database capacity depends upon the DMS tablespace container size and
pagesize. In DMS the space is pre allocated.

deogirikar./
#####

Sep 19 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.