Is it possible to restore a database that is setup with SMS type containers to DMS containers. I have tried it and keep getting an error saying tablespace is not accessable. I have listed the command below that I am running. I have never tried this before. THis is on AIX 5.2 and DB2 V8 fixpak 3.

RESTORE DB REPBKP
from /db2/ETD/sapdata5
TAKEN AT 20040330125621
INTO REPBKP
REPLACE EXISTING;
SET TABLESPACE CONTAINERS FOR 0
IGNORE ROLLFORWARD CONTAINER OPERATIONS
USING
(file '/db2/ETD/sapdata1/REPBKP/syscatspace.container001' 3000,
file '/db2/ETD/sapdata2/REPBKP/syscatspace.container002' 3000,
file '/db2/ETD/sapdata3/REPBKP/syscatspace.container003' 3000,
file '/db2/ETD/sapdata4/REPBKP/syscatspace.container004' 3000,
file '/db2/ETD/sapdata5/REPBKP/syscatspace.container005' 3000);

Didn't you forget the 'REDIRECT' clause?

Unfortunately, no. You need to export->drop->create->load/import to move the table to a DMS tablespace.

Thanks for the reply thats what I thought, I was hoping I was missing something.