Reduce Containers does not work for multiple tablespaces.It only applies to one.
To reproduce the issue, you need two or more tablespaces.
You can use the ones you already have, but if needed, you can create new ones.
See the example below to create them.
CREATE LARGE TABLESPACE test1tb
IN DATABASE PARTITION GROUP IBMCATGROUP
PAGESIZE 4K
MANAGED BY AUTOMATIC STORAGE
USING STOGROUP IBMSTOGROUP
EXTENTSIZE 4
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
AUTORESIZE YES
INITIALSIZE 32M
NO FILE SYSTEM CACHING
DATA TAG INHERIT
;
CREATE LARGE TABLESPACE test2tb
IN DATABASE PARTITION GROUP IBMDEFAULTGROUP
PAGESIZE 4K
MANAGED BY AUTOMATIC STORAGE
USING STOGROUP IBMSTOGROUP
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
BUFFERPOOL IBMDEFAULTBP
AUTORESIZE YES
INITIALSIZE 32M
NO FILE SYSTEM CACHING
DATA TAG INHERIT
;
Go to Object Explorer | Tablepaces and select them (ctrl r-click ).
R-click and select "Reduce Containers"
In the wizard , change Reduce size by to 90
Click on Show script
The script is
ALTER TABLESPACE TEST1TB REDUCE 90;
COMMIT;
ALTER TABLESPACE TEST2TB REDUCE MAX;
COMMIT;
As you can see, only the first statement has the new value, even though both tablespaces were selected.
Also, when you try to enter the settings for the different tablespaces and click on a tablespace other than the initially selected one, the settings window disappears and does not reappear for any of the other tablespaces — it simply vanishes.
WORKAROUND
Modify the script manually
STATUS
Waiting for fix in a future release of Toad for DB2
