Reducing the Size of Containers in a DMS Table Space
You now also have the ability to reduce the size of existing table space containers. Prior to v8, you could use the RESIZE option on the ALTER TABLESPACE statement to increase the size of one or more containers in a DMS table space, but you could not reduce the size of table space containers. Now you can reduce their size to a specified value (using the enhanced RESIZE option), or by a specified value (using the new REDUCE option). For example:
db2 connect to sample db2 list tablespace containers for 3 show detail db2 alter tablespace ts1 reduce (file 'D:\tsc1' 100) db2 alter tablespace ts1 resize (file 'D:\tsc1' 512) db2 list tablespace containers for 3 show detail db2 connect reset
You ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.