Hi Scott, Is USERSPACE1 an SMS or DMS tablespace? If it is an SMS tablespace then it cannot be altered using ALTER TABLESPACE. The only way to add space is to do one of the following:
- Expand the underlying file system or free up space on it by moving non- DB2 files somewhere else. - Backup the tablespace (or database if log retain isn't on) and do a redirected restore of the tablespace, specifying extra containers and/or larger ones (ones with more disk space available to them). If USERSPACE1 is a DMS tablespace then you can definitely make it larger using the ALTER TABLESPACE statement. You can add new containers and/or extend existing ones. You do NOT have to disconnect all users from the database and transactions can be still be processing when you do it. Depending on your current container configuration and what you do to them, a rebalance may or may not be started to shuffle data around. Even during that rebalance though, you can still access the data in the tablespace. Kelly Kelly Schlamb DB2 Universal Database Development, IBM Toronto Lab, Canada Email: [EMAIL PROTECTED] DB2 Online Support Website: http://www.ibm.com/software/data/db2/udb/winos2unix/support scott m <azscott66@yahoo. To: [EMAIL PROTECTED] com> cc: Sent by: Subject: [DB2EUG] Resizing db2 tablespace owner-db2eug@Lugw ash.org 12/18/2002 07:43 PM Please respond to scott m I need to resize userspace1 with an 'alter tablespace' SQL statement. My question is this: do all applications have to be disconnected from the database before the tablespace is altered? I cannot find the answer in any of the DB2 manuals that I looked at. My understanding is that the alter becomes effective immediately upon commit but I don't know if transactions can be processing while the alter statement is processed. Thanks. __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
