Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: define tablespace containers in redirected restore

    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

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

    Re: define tablespace containers in redirected restore

    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.

  3. #3
    Join Date
    May 2003
    Posts
    369

    why ignore rollforward?

    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

Posting Permissions

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