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
