Hello Experts,

Is there any way like "get_dbsize_info" to calculate db size in DPF environment.

Thanks


Regards,
Prashant

what version are you on? and why do you think the command is not available on dpf?

To ensure that the data is returned by all partitions for a global table space snapshot, the database must be activated

https://www-304.ibm.com/support/docv...id=swg1IY80746

We are running on V9.5 FP6a.

I was trying "get_dbsize_info" only from catalog node. It shows size of 70TB but actual db size is more than 160TB

Thanks for reply.

Hi,

Anybody has any idea on this.

bash-3.2$ db2 "call get_dbsize_info(?,?,?,0)"

Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2011-12-06-23.29.14.134570

Parameter Name : DATABASESIZE
Parameter Value : 70372224860160

Parameter Name : DATABASECAPACITY
Parameter Value : -1

Return Status = 0

Did you activate the db?

"To ensure that the data is returned by all partitions for a global table space snapshot, the database must be activated" as sathyaram_s mentioned.

sorry for the delay.
The database is already active and applications are running on it.

Your catalog partition has 70TB of data? Verify the size reported by get_dbsize_info with your what's reported by db2pd -tablespaces from all partitions.