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.