I just restored a database to a different server and during container setup I forgot to reduce the container size since there was over storage allocated in the inital db.
for example..tablespace id 3 has 8G allocated and it has only used 15% of it and has 3 containers assigned..
so i used db2 alter tablespace reduce (all 1000 M)
it worked the first time
I tried it again..
It failed stating not enough space..but there is still 5G available..anything else that i have to worry about?
i have like 10 more tablespaces to do..any suggestions or other way of reducing space?