deciphering output from CALL GET_DBSIZE_INFO(?, ?, ?, 0)

dbforumsid · #1 (**permalink**) 03-31-11, 12:20

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
425GB?

ARWinner · #2 (**permalink**) 03-31-11, 12:55

Yes it would.

Andy

n_i · #3 (**permalink**) 03-31-11, 13:23

No it would not. 425273446400 bytes is just a bit more than 396 GB.

dbforumsid · #4 (**permalink**) 03-31-11, 14:07

now I'm really confused. I would have thought that it was 425GB .. how did you come up with 396?

n_i · #5 (**permalink**) 03-31-11, 14:28

1 GB is 2**30 bytes, isn't it?

ARWinner · #6 (**permalink**) 03-31-11, 14:35

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

Andy

dbforumsid · #7 (**permalink**) 03-31-11, 15:25

for that formula, does it matter if they are not all 4k pages?

ARWinner · #8 (**permalink**) 03-31-11, 16:25

The formula is for converting bytes to GB. Pages are something else entirely. The CALL GET_DBSIZE_INFO handles your tablespaces properly already.

Andy