Hi,
db2 “call get_dbsize_info(?,?,?,1)”
When above statement is executed I got below output

Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2008-03-26-12.14.44.187000

Parameter Name : DATABASESIZE
Parameter Value : 23191552


Parameter Name : DATABASECAPACITY
Parameter Value : 11580578304

Return Status = 0

It shows database capacity around 10 G??????
but my free disk space is 2.7G
Full disk space is 12 G
Used disk space is 8.3 G

When free disk space is only 2.7G then how it can show database capacity around 10 G?????????????????????????????????

Thanks
Pawan

I am fairly certain that maximum capacity is not based on the HD size but on the number and pagesize of your tablespaces.

Andy

Your numbers on the disk space do not line up: Free disk space + used disk space = 11 GB in your case - but you state you have 12 GB.