View previous topic :: View next topic
|
Author |
Message |
kumar.15111983
New User
Joined: 27 Feb 2008 Posts: 1 Location: Chennai
|
|
|
|
how to resize the tablespace? |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
As Dick would say, welcome to the forums....
Is this a DB2 question? |
|
Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005 Posts: 165 Location: Bangalore
|
|
|
|
Quote: |
ALTER TABLESPACE statement
The ALTER TABLESPACE statement is used to modify an existing table space in the following ways:
* Add a container to, or drop a container from a DMS table space; that is, a table space created with the MANAGED BY DATABASE option.
* Modify the size of a container in a DMS table space.
* Add a container to an SMS table space on a partition that currently has no containers.
* Modify the PREFETCHSIZE setting for a table space.
* Modify the BUFFERPOOL used for tables in the table space.
* Modify the OVERHEAD setting for a table space.
* Modify the TRANSFERRATE setting for a table space.
* Modify the file system caching policy for a table space.
|
|
|
Back to top |
|
|
|