DB2 UDB V8.2 (FP10)
AIX 5.2.0.0
I noticed total usage of all filesystems which were used for occupancy of each filesystems which were used for these tablespaces is 325GB where as the database size is 200GB only.
I restored (redirect) a backup of a database of 200GB size into a new database with combination of DMS and SMS tablespaces. I was having 250GB free space in all the file systems before restore which I used for the containers for this database TS's. Finally the RESTORE failed because all the containers were running out of space. Finally I got added more space to each filesystem and restored successfully.
So, what way I should check for the freespace in this kind of senario?
thank you,
-Ram