Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Arrow Unanswered: Restore database (SMS to DMS)

    Hi:

    Is it possible that during the restore database redirect command, change the SMS tablespaces to DMS?

    I have a situation where I have a backup image of database which has all the tablespaces as SMS. I need to create a copy of this same database BUT change some of the SMS tablespaces to DMS for some testing purposes. Is it possible to achieve with restore command? If not what other way can be used except creating a brand new database and then import/export of data?

    DB: DB2 UDB V7 FP9 on Windows

    Thanks in advance.

    dollar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Restore database (SMS to DMS)

    Restore Command cannot do this

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Re: Restore database (SMS to DMS)

    Yes, thats what I concluded from the documentation as well. Another thing I found is that Quest central for database tool by Quest has the capability to do this in their alter tablespace screen. On the background it does export, drop tables, create tablespace and import the data back. One can do it manually as well. But using the tool, it's just easy and it takes care of dependcies.

    dollar

    Originally posted by sathyaram_s
    Restore Command cannot do this

    Sathyaram

Posting Permissions

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