Hi Francesco, If you are on a relatively recent level of V7 (or on V8) then you can use the db2relocatedb tool to help you move containers (I can't remember exactly which fixpak it started shipping in -- but any fixpak released in 2002 should contain it).
I believe it is discussed in the release notes but if you can't figure out how to use it, let me know and I'll jot a few instructions down for you. Basically, you need to shut the database down, manually move the container(s) to the new location, and then run the db2relocatedb tool. You provide a configuration file to the tool (telling it about the database and what changes you want) and it will go out and change things to point to the new container location(s). And just as an FYI, you can also use the tool to change the name of a database or move it to a new instance. Kelly Kelly Schlamb DB2 Universal Database Development, IBM Toronto Lab, Canada Email: [EMAIL PROTECTED] Phone: 905-413-2469 DB2 Online Support Website: http://www.ibm.com/software/data/db2/udb/winos2unix/support "Borgoglio, Francesco" To: "'DB2 Open System List'" <[EMAIL PROTECTED]> <F.Borgoglio@cedac cc: riovest.it> Subject: [DB2EUG] Move tablespace containers Sent by: owner-db2eug@Lugwa sh.org 12/30/2002 05:40 AM Please respond to "Borgoglio, Francesco" Hi Gurus, I new chap in this list and i new in db2 database, too. I would like to know if it's possible to move containers from a location to another, not only with the "set tablespaces containers" command, strictly during a database restore, but always. Can anyone help me? Thank you so much. Best regards, Francesco Borgoglio It is inexcusable for scientists to torture animals; let them make their experiments on journalists and politicians. - ::: 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
