var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: deciphering output from CALL GET_DBSIZE_INFO(?, ?, ?, 0)
I am running DB2 on Windows version 9.5
Ran this command to get the size of my Database
CALL GET_DBSIZE_INFO(?, ?, ?, 0)
here is the output:
Value of output parameters
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2011-03-31-12.09.56.967000
Parameter Name : DATABASESIZE
Parameter Value : 425273446400
Parameter Name : DATABASECAPACITY
Parameter Value : 692038145536
Return Status = 0
might sound like a stupid question... but does this put my database at
No it would not. 425273446400 bytes is just a bit more than 396 GB.
now I'm really confused. I would have thought that it was 425GB .. how did you come up with 396?
1 GB is 2**30 bytes, isn't it?
To go from bytes to GB you use this formula (I was too lazy to do it at first):
(((425273446400/1024) = KB ) / 1024 = MB) / 1024 = GB which is 396.066
for that formula, does it matter if they are not all 4k pages?
The formula is for converting bytes to GB. Pages are something else entirely. The CALL GET_DBSIZE_INFO handles your tablespaces properly already.
You may want to see Wikipedia.
Giga- - Wikipedia, the free encyclopedia
When referring to information units in computing, such as gigabit or gigabyte, giga may sometimes mean 1073741824 (2**30