Why is the database size is larger than the server disk space?

[rednemesis]

Good Day everyone!

When I calculated the size of the database on my system using the formula:

Total Page size x Page size (4096) = Total Database Size
Used page size x Page size (4096) = Total Used Page Size

I then add up the results from all the tablespaces.
My question is, with the result, why is the size of Total Database Size and Total Used Page size is larger than the disk space size from the command 'df' in linux.

Please enlightened me. Many Thanks!

[vijay2082]

Hi,

You have miscalculated the DB size. Use below command to know the exact size and then match accordingly.

db2 "connect to <db_name>"
db2 "CALL GET_DBSIZE_INFO (?, ?, ?, 0) "

Look in the information centre for details on the output of the query which will retuirn db size in bytes and how it calculates the database size.

Cheers, Vijay