Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

how to resize the tablespace?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kumar.15111983

New User


Joined: 27 Feb 2008
Posts: 1
Location: Chennai

PostPosted: Thu May 01, 2008 3:42 pm    Post subject:
Reply with quote

how to resize the tablespace?
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu May 01, 2008 7:12 pm    Post subject:
Reply with quote

As Dick would say, welcome to the forums....
Is this a DB2 question?
Back to top
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Fri May 02, 2008 10:12 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm
No new posts BMC UNLOAD for a LOB tablespace JyothsnaNayak DB2 2 Wed Jul 29, 2015 2:02 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us