I think for this one you may have to do a bit of work.
1) On the target system, create the db with minimum options.
db2 "create db COMPDB on <path>"
2) Issue your command:
db2 "restore database COMPDB From /db2back/inst04 into COMP REPLACE
EXISTING redirect"
I think this should work.
You can then refefine any or all containers for any or all tablespaces,
inclyding syscatspace.
Also, if you come from a disk image, make sure you have access to the exact
<path> where the image is stored.
I presume here that </db2back/inst > is the actual path. Remeber that the
backup command expands that path in the actual backup.
HTH, Pierre.
"Shi, Zhong" wrote:
> Hi, List,
>
> I try to restore a database backup to a new database in a different instance
> in different machine in AIX. Look at the command reference I know I need 3
> steps to make it happen (we can not use Control Center to do it due to
> security setup). The original database is called COMPDB and is in instance
> inst04. the new database will be call the same name but will be in inst07 in
> other machine. I have never passed the first step of the three of redirect
> restore. after enter
>
> > db2 "restore database COMPDB redirect"
> or
> > db2 "restore database COMPDB From /db2back/inst04 into COMP redirect"
>
> I did not get a prompt back. So I can't perform the second step.
>
> Please give me some advise and the command in each steps to accomplish the
> task.
>
> Thank you.
>
> zhong
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
begin:vcard
n:Saint-Jacques;Pierre
tel;cell:514-233-8679
tel;fax:514-737-1268
tel;work:514-737-4515
x-mozilla-html:FALSE
org:SES Consultants Inc.
adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada
version:2.1
email;internet:[EMAIL PROTECTED]
title:President
fn:Pierre Saint-Jacques
end:vcard
