I am trying redirected restore and it is failing with the following errors please help. I am using SMS tablespaces

redirected restore script commands::


db2 "restore db MARKETDB replace existing redirect"

db2 "set tablespace containers for 0 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SQLT0000.0')"


db2 "set tablespace containers for 2 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0002.0', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SQLT0002.0')"


db2 "set tablespace containers for 3 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE')"


db2 "set tablespace containers for 32 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/SYSTOOLSTMPSPACE', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/SYSTOOLSTMP
SPACE')"



db2 "set tablespace containers for 49 using (path '/home/db2inst1/db2inst1/NODE0000/SQL00001/QCTEMPTS', path '/db2fs/marketdb/db2inst1/NODE0000/SQL00001/QCTEMPTS')"


db2 "restore db MARKETDB continue"



Output messages file for the above commands::






SQL1277N Restore has detected that one or more table space containers are
inaccessible, or has set their state to 'storage must be defined'.
DB20000I The RESTORE DATABASE command completed successfully.
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SQL0298N Bad container path. SQLSTATE=428B2
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SQL0298N Bad container path. SQLSTATE=428B2
SQL1277N Restore has detected that one or more table space containers are
inaccessible, or has set their state to 'storage must be defined'.
DB20000I The RESTORE DATABASE command completed successfully.

As it states,container path is not correct.The path you have mentioned is not exist in the box OR the path being used by some other container.

run ls -l for all the paths.
say, ls -l /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0

if you see any file(s) under this(SQLTAG.NAM),just drop it and rerun your SET stmts followed by RESTORE CONTINUE.If you get any error ,means your path is not correct..specify the correct one.

--Naga