Skip to Content
0
Former Member
Mar 05, 2009 at 09:57 AM

DB2 V 8.2 AUTOMATIC DMS

34 Views

How can we resize the containers which are under tablespaces as automatic.

we tried to Lower the HWM to a great extent but still the Free Space is locked by Tablespaces.

we got 160 GB Free Space Locked by two Tablespaces XI#DBD,XI#BTABD and now we are left with 17GB Free OS Space.

Now we want to release the Space to OS, so that any Space request from any other Tablespace can be equally processed.

we tried to resize the containers but DB2 is not allowing to do so as it is configured as automatic.

How can we work in an DB2 v 8. 2 environment where Space Optimization is not Possible.

do we got any solution for this major drawback

Thanks & Regards,

Rama krishna