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
 

 

Increase Table Space Is Possible with Alter Statement?

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

New User


Joined: 11 Apr 2006
Posts: 93

PostPosted: Tue Dec 26, 2006 11:17 am    Post subject: Increase Table Space Is Possible with Alter Statement?
Reply with quote

I want to increase Table space,It is possible thru Alter statement or ia there any other way to Incrase The Table Space?
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Dec 26, 2006 11:24 am    Post subject:
Reply with quote

Hi There,

Please refer to below link

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0000890.htm

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/t0022269.htm
Back to top
View user's profile Send private message
ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Thu Dec 28, 2006 4:04 pm    Post subject: Re: Increase Table Space Is Possible with Alter Statement?
Reply with quote

You cannot use ALTER TABLESPACE to change some attributes of your table
space. For example, you must use other methods to change SEGSIZE or the
number of partitions or to convert it to a large table space. The following topics
describe these methods:

There are different ways in which u can increase the space.
traditionla way of:
Unload
DROP
RECREATE
LOAD

Remeber the all the tables in the tablespace should also be dropped and recreated


Or the simpler way of using RE-ORG
-----------------------------------------
Changing the space allocation for user-managed data sets
If the table space is supported by user-managed data sets, use this procedure to
change the space allocation:
1. Run the REORG TABLESPACE utility, and specify the UNLOAD PAUSE
option.
2. Make the table space unavailable with the STOP DATABASE command and the
SPACENAM option after the utility completes the unload and stops.
3. Delete and redefine the data sets.
4. Resubmit the utility job with the RESTART(PHASE) parameter specified on the
EXEC statement.
The job now uses the new data sets when reloading.
Use of the REORG utility to extend data sets causes the newly acquired free space
to be distributed throughout the table space rather than to be clustered at the end.
Back to top
View user's profile Send private message
babu_hi

New User


Joined: 11 Apr 2006
Posts: 93

PostPosted: Thu Dec 28, 2006 8:03 pm    Post subject:
Reply with quote

Thanks Ravi.
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 Alter &DATENS field in HEADER1 Angad DFSORT/ICETOOL 4 Mon Apr 24, 2017 11:49 am
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am
No new posts Need inputs on Space requirement and... ashek15 IMS DB/DC 0 Sat Apr 01, 2017 8:26 am


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