Hi all,

I've two DB2 instances on the one machine (DEV and TEST) on DB2/LINUX 9.1.2. I can backup and do a re-directed restore of database successfully on the same instance, but on a cross instance restore I get the following message at the end of the restore:

DEV.> restore database itest2 continue;
SQL2563W The restore process has completed successfully, but one or more
table spaces from the backup were not restored.

All the SMS tablespaces are left in a Offline/Drop Pending state. This doesn't happen for on a same instance restore.



Steps I'm following to get a copy of a TEST instance database called itest2 onto the DEV instance as dev1. e.g.

BACKUP DATABASE itest2 TO "/data02/db2/backups" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

restore database itest2
from "/data02/db2/backups"
taken at 20080701134322
into dev1
redirect without rolling forward
without prompting;

set tablespace containers for 0 using (path '/data01/db2/DEV/dev1/cat');
set tablespace containers for 1 using (path '/data01/db2/DEV/dev1/tmp');
set tablespace containers for 2 using (path '/data01/db2/DEV/dev1/usr');

restore db itest2 continue;


Is there something I'm missing with a cross instance restore?

thanks
Paul

I would check the diagnosis log to see if there is an error message. I assume that you are logged on as the instance owner for the instance you are installing to.

Is there a permissions problem with the new instance id on that mount point?

Hi Marcus,

The login being used for the restore is the owner of the DEV instance where the 'into' database resides.

Yes, in the DEV db2diag.log there are file access errors on files that make up the
database on the TEST instance.

To the restore command I added the on ... dbpath on clauses and the restore then worked.

e.g.

restore database itest2
from "/data02/db2/backups"
taken at 20080701134322
on /home/dev
dbpath on /home/dev
into dev1
redirect without rolling forward
without prompting;


thanks
Paul