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

size of the database

P: n/a
Hi,

How can i estimate the approximate size of the database as a whole.
This is required because i want to take the backup of the database and
have to make sure that that much space is available.

Thanks

Rahul

Sep 10 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sep 10, 3:07 pm, Rahul Babbar <rahul.babb...@gmail.comwrote:
Hi,

How can i estimate the approximate size of the database as a whole.
This is required because i want to take the backup of the database and
have to make sure that that much space is available.

Thanks

Rahul
use
db2 CALL GET_DBSIZE_INFO(?, ?, ?, 0)
on my systems the compressed bkp on 8.2.7 takes approx 1/4 of dbsize

Sep 10 '07 #2

P: n/a
On Sep 10, 7:29 pm, rahul <rahul...@gmail.comwrote:
On Sep 10, 3:07 pm, Rahul Babbar <rahul.babb...@gmail.comwrote:
Hi,
How can i estimate the approximate size of the database as a whole.
This is required because i want to take the backup of the database and
have to make sure that that much space is available.
Thanks
Rahul

use
db2 CALL GET_DBSIZE_INFO(?, ?, ?, 0)
on my systems the compressed bkp on 8.2.7 takes approx 1/4 of dbsize
Thanks

I am getting the following result
Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2007-09-12-00.59.40.988803

Parameter Name : DATABASESIZE
Parameter Value : 40190345216

Parameter Name : DATABASECAPACITY
Parameter Value : 50635932148

Return Status = 0
Does the database capacity means the maximum size of the database?
I see that the database capacity and database size are pretty close(50
GB and 40 GB)?
I guess i will have to create another database

Rahul

Sep 11 '07 #3

P: n/a
On Sep 11, 12:38 pm, Rahul Babbar <rahul.babb...@gmail.comwrote:
On Sep 10, 7:29 pm, rahul <rahul...@gmail.comwrote:
On Sep 10, 3:07 pm, Rahul Babbar <rahul.babb...@gmail.comwrote:
Hi,
How can i estimate the approximate size of the database as a whole.
This is required because i want to take the backup of the database and
have to make sure that that much space is available.
Thanks
Rahul
use
db2 CALL GET_DBSIZE_INFO(?, ?, ?, 0)
on my systems the compressed bkp on 8.2.7 takes approx 1/4 of dbsize

Thanks

I am getting the following result
Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2007-09-12-00.59.40.988803

Parameter Name : DATABASESIZE
Parameter Value : 40190345216

Parameter Name : DATABASECAPACITY
Parameter Value : 50635932148

Return Status = 0

Does the database capacity means the maximum size of the database?
I see that the database capacity and database size are pretty close(50
GB and 40 GB)?
I guess i will have to create another database

Rahul
Also,

Is it possible to view the size occupied by various schemas in the
database?

Rahul

Sep 11 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.