Hi! I have a database backup file from system A and I need to restore it onto system B.
SYstem A and B have the same OS, the two DB2 instances are at the same version. New database was created and it has the same tablespace names and the same number of containers. However, the root directory names are different between the two systems. The source system A has "/rtmq01" the instance name as the root, and the target system B has "data" as the root.

I used "TO" command to specify the target file directory, but I'm not sure how many levels is the correct db level, should I stop before or after the common subdirectory name for all the tablespaces?

I'm also getting a weird permission error that seems a simple REDIRECT will not help, because the target database was created with default, it does not have a tablespace specific for catalog :

2006-06-12-13.34.19.643655-420 I1136242C294 LEVEL: Error
PID : 20373 TID : 1 PROC : db2bm.15390.0 0
INSTANCE: rtqa3 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateAndLockParent, probe:920
MESSAGE : Failed at directory /rtmqi01.

2006-06-12-13.34.19.644106-420 I1136537C418 LEVEL: Error
PID : 20373 TID : 1 PROC : db2bm.15390.0 0
INSTANCE: rtqa3 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:805
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2006-06-12-13.34.19.654808-420 I1136956C393 LEVEL: Error
PID : 20373 TID : 1 PROC : db2bm.15390.0 0
INSTANCE: rtqa3 NODE : 000
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:805
MESSAGE : Error acquiring container 0
(/rtmqi01/dbsys0001/RTMQ01/TBLSPACE/catalog.ts1) for tbsp 0. Rc = 840F0001

Anyhelp in resolving the root directory and the tablespace catalog issues are greatly appreciated!

Regards, Nancy

Go to system A and issue the following command:

db2 list db directory

This will tell you what directory the database is installed at, so you install the database at an appropriate directory on System B.

The database directory, and the tablespace directories, must be owned by the instance owner, not root.

I think Nancy will need to use REDIRECT option in any case - the container paths seem to be different between the two servers. Just don't create the database on the target system prior to the restore - let restore do it.