Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Unanswered: restore SMS to DMS containers

    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);
    David Quigley

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: restore SMS to DMS containers

    Originally posted by quigleyd

    RESTORE DB REPBKP
    from /db2/ETD/sapdata5
    TAKEN AT 20040330125621
    INTO REPBKP
    REPLACE EXISTING;
    Didn't you forget the 'REDIRECT' clause?

  3. #3
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Re: restore SMS to DMS containers

    Originally posted by quigleyd
    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);
    Unfortunately, no. You need to export->drop->create->load/import to move the table to a DMS tablespace.
    --
    Jonathan Petruk
    DB2 Database Consultant

  4. #4
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: restore SMS to DMS containers

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •