Is there anything else to gather database size info?

**juraj.hrapko@gmail.com** · Apr 8 '08, 02:15 PM

Re: Is there anything else to gather database size info?

Backup file contains some more info about the DB, than only the data.
I think, this could be the reason for having bigger backup than the db
size. Anyway, you can use the compress switch with the backup
command :)

On Apr 8, 7:59 am, Laurence <worldwide...@g mail.comwrote:

Hi folks,
>
My database DB03 is circular logging. I called the db2 procedure:
get_dbsize_info to get the database size as below:
>
Parameter Name : SNAPSHOTTIMESTA MP
Parameter Value : 2008-04-08-06.39.49.518070
>
Parameter Name : DATABASESIZE
Parameter Value : 24666112
>
Parameter Name : DATABASECAPACIT Y
Parameter Value : 6063167488
>
then, I did the db backup. The backup image size as below:
>
-rw-r----- 1 db2inst1 db2grp1 54308864 April 7 23:26
DB03.0.db2inst1 .NODE0000.CATN0 000.20080407232 545.001
>
The database size info is not the same or close to the backup image
size!! Can somebody tell me what's going on?
>
Should we not use db2 procedure get_dbsize_info to gather database
size info? If so, what else it should be used for gathering database
size info?
>
Laurence

**Laurence** · Apr 9 '08, 02:45 AM

Re: Is there anything else to gather database size info?

Well, the value that is returned by the db2 procedure
'get_dbsize_inf o' is the same as the size of total tablespaces within
database DB03.

As I do the 'du -sb $HOME/db2inst1/NODE0000/SQL00003', the summary
size of DB03 Path is 41152360. That is more close to the backup image
size.

For your information.

Laurence

Is there anything else to gather database size info?

Is there anything else to gather database size info?

Comment

Comment