|
|
| Author |
Message |
kumar.15111983
New User
Joined: 27 Feb 2008
Posts: 1
Location: Chennai
|
|
|
|
| how to resize the tablespace? |
|
| Back to top |
|
 |
References
|
 Posted: Thu May 01, 2008 3:42 pm Post subject: Re: |
|
|
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 1189
Location: At my desk
|
|
|
|
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: 169
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 |
|
|
|
|
