var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculate DB size in DPF env
Is there any way like "get_dbsize_info" to calculate db size in DPF environment.
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
Visit the new-look IDUG Website
, register to gain access to the excellent content.
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.
Last edited by prashant44; 12-05-11 at 21:42.
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-188.8.131.52570
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.