You do need to copy the containers before.
You can use write suspend but also ensure that nothing else uses those
paths. You can also put the tablespace offline.
Your script seems to be all right.
You do need to specify the full path in the relocate.cfg file.
This approach shoyuld work.
Regards, Pierre.

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Marco MEDINA"
<db2udbdba-ezmlmshield-x93862375.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, July 27, 2006 10:43 AM
Subject: relocating containers


> Hi all,
>
> I am thinking about moving containers of a specific tablespace. I
>
> have look in db2relocatedb Command, but I still have some doubts:
>
> - I have to copy the containers to the new location before?
>
> - To move the containers, should I put the tablespace offline or make a
> set
>
> write suspend or what?
>
> - What would be the steps?
>
> - There are many tablespace containers in this path. I want to change only
>
> the containers of a specific tablespace. Is it possible?
>
>
>
>
>
> I imagine a command like :
>
> db2relocatedb -f relocate.cfg
>
> where relocate.cfg
>
> DB_NAME=xxxdb001
>
> DB_PATH=/...
>
> INSTANCE=db2xxx
>
> CONT_PATH=/aplic/old/file,/aplic/new/file (or should be only the
>
> path?)
>
>
>
>
>
>
>
> Best regards,
>
>
>
> -------------------------------------------------------------------------
>
> Marco Aurélio Medina de Oliveira - 5619
>
> HSBC/IT/OPERATIONS/TS/DBA
>
>
>
>
>
> -----------------------------------------
>
> This E-mail is confidential. It may also be legally
>
> privileged. If you are not the addressee you may not
>
> copy, forward, disclose or use any part of it. If
>
> you have received this message in error, please delete
>
> it and all copies from your system and notify the sender
>
> immediately by return E-mail.
>
> Internet communications cannot be guaranteed to be timely,
>
> secure, error or virus-free. The sender does not accept
>
> liability for any errors or omissions.
>
>
>
> Esta mensagem pode conter informações confidenciais e/ou
>
> privilegiadas. Se você não for o destinatário ou a pessoa
>
> autorizada a recebê-la, não pode usar, copiar ou divulgar
>
> as informações nela contidas ou tomar qualquer ação baseada
>
> nelas. Se você recebeu esta mensagem por engano, por favor,
>
> avise imediatamente o remetente, e em seguida, apague-a.
>
> Comunicações pela Internet não podem ser garantidas quanto
>
> à segurança ou inexistência de erros ou de vírus.
>
> O remetente, por esta razão, não aceita responsabilidade por
>
> qualquer erro ou omissão no contexto da mensagem decorrente
>
> da transmissão via Internet.
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page