Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    27

    Unanswered: redirected restore

    hi all
    i have a small question.
    can we change the SMS tablespace containers to DMS tablespace containers during redirected restore operation.
    i want to change my SMS tablespaces to DMS tablespaces.
    if not this way is there any other way to change from SMS to DMS tablespaces.
    my db is db2 V8.2fp5solaris.
    and if it is possible to do so,can we do a redirected restore from solaris(V8.2)to aix(V9.1)?.

    any help is appreciated
    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by rajaryan4545
    can we change the SMS tablespace containers to DMS tablespace containers during redirected restore operation.
    No. You will have to use the db2look/db2move approach.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    redirected restore is intent to redirect storage containers from one file system path to another. Redirected restore does not support any other operation like transformation between SMS and DMS.

    SMS to DMS conversion is not possible during redirect restore. Like n_i noted the simpliest approach is to use db2look and db2move commands.

    Moving backup image between Solaris and AIX depends if Solaris is x64 or SPARC. See more at: http://publib.boulder.ibm.com/infoce...c/c0005960.htm

    Hope this helps,
    Grofaty

Posting Permissions

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