size of the database

[Rahul Babbar]

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

[rahul]

On Sep 10, 3:07 pm, Rahul Babbar <[e-mail]:

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

[Rahul Babbar]

On Sep 10, 7:29 pm, rahul <[e-mail]:

On Sep 10, 3:07 pm, Rahul Babbar <[e-mail]:

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

[Rahul Babbar]

On Sep 11, 12:38 pm, Rahul Babbar <[e-mail]:

On Sep 10, 7:29 pm, rahul <[e-mail]:

On Sep 10, 3:07 pm, Rahul Babbar <[e-mail]:

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