We are performing a redirected restore in DB2 UDB 7.2 on AIX 5.2. I am trying to redirect many SMS containers to two filesystems.

filesystems for sms tablespace containers
/db2data
/db2data/userts

tablespace containers:

userspace1
db2 "set tablespace containers for 2 using ( path 'userts')";
this worked

userspace2
db2 "set tablespace containers for 2 using ( path 'db2data/userts')";
this generates the bad container error

db2 "set tablespace containers for 2 using ( path 'userts')";
this generates the tablespace container already in use error

How would I solve this problem? Thanks

You need to fully qualify the path for SMS

SET TABLESPACE CONTAINERS FOR 27
IGNORE ROLLFORWARD CONTAINER OPERATIONS
USING
(PATH '/db2data/userts' );


You should also use the " Replace EXISTING " option in the restore command.

Thanks. This solved the set tablespace containers problem during my redirected restore. Since we are enabled for rollforward log recovery with our database why would I turn this option off in the redirected restore if I need a point in time recovery? Thanks

Scott