I am working on AIX platform and DB2 V8.2.2 version.
I have 5 instances on a server and 7 databases which amount to 100GB. But when I use df -k it shows that it consumes 168 GB. I would like to know which Instance consumes how much space and why is the total space used 168GB. I would like to free up the 68 GB. Any suggestions please.
For each of the databases find out the location where the datafiles are residing. run -->
du -k /datafilelocation
this will tell you the space consumed by each datafile. Just add up and find out the total. Do the same for database log files too.
There are many other ways to find out the space consumed by each database. Above mentioned is the one of them.