Professional Web Applications Themes

restore into new db on in same instance...question - IBM DB2

Hi, I currently have a db (uw_db) using 30 DMS devices running on a server. I want to create a copy of this db to ( uw_db_dev) on the same server and instance. I extract (db2look) all the devices from the db uw_db , do a slight name change to each device iwth in the output file and re-create them taking the file as imput. Then do a restore db into newdb. WOuld I have problems with the SMS for the temp user spaces ? if I did this Or would it be better to do a restore with redirect ...

  1. #1

    Default restore into new db on in same instance...question

    Hi,
    I currently have a db (uw_db) using 30 DMS devices running on a
    server. I want to create a copy of this db to ( uw_db_dev) on the same
    server and instance.

    I extract (db2look) all the devices from the db uw_db , do a slight
    name change to each device iwth in the output file and re-create them
    taking the file as imput. Then do a restore db into newdb. WOuld I
    have problems with the SMS for the temp user spaces ? if I did this

    Or would it be better to do a restore with redirect ?
    Do to the amount of DMS devices I would rather automate as much as
    possible.
    Which option is best ?
    thanks
    pete
    Peter Sands Guest

  2. #2

    Default Re: restore into new db on in same instance...question

    Pete,

    faster is I zhink the redirected restore or u can use the db2relocatedb :

    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce[/url]
    nter.d2w/report?target=mainFrame&fn=t0006411.htm

    Regards,
    Joachim

    "Peter Sands" <peter_sandstechemail.com> schrieb im Newsbeitrag
    news:6b009995.0307151028.2f6d35posting.google.com ...
    > Hi,
    > I currently have a db (uw_db) using 30 DMS devices running on a
    > server. I want to create a copy of this db to ( uw_db_dev) on the same
    > server and instance.
    >
    > I extract (db2look) all the devices from the db uw_db , do a slight
    > name change to each device iwth in the output file and re-create them
    > taking the file as imput. Then do a restore db into newdb. WOuld I
    > have problems with the SMS for the temp user spaces ? if I did this
    >
    > Or would it be better to do a restore with redirect ?
    > Do to the amount of DMS devices I would rather automate as much as
    > possible.
    > Which option is best ?
    > thanks
    > pete

    Joachim Müller Guest

  3. #3

    Default Re: restore into new db on in same instance...question

    Pete,

    1. Create set containers script for all 30 DMS tablespaces
    2. Backup uw_db (offline is better as you don't need to rollforward)
    3. do a REDIRECTED RESTORE (you can use the SET CONTAINERS script
    create in the begining).

    I hope this helps....
    DB2UDBDBA Guest

  4. #4

    Default Re: restore into new db on in same instance...question

    It depends on the size of your database. if this is a small database just do a
    EXPORT and IMPORT OR
    use
    REDIRECTED RESTORE

    Cheers...
    Shashi Mannepalli

    [email]dbausa.com[/email] (DB2UDBDBA) wrote in message news:<ca901ef9.0307160622.cd0cdd1posting.google.c om>...
    > Pete,
    >
    > 1. Create set containers script for all 30 DMS tablespaces
    > 2. Backup uw_db (offline is better as you don't need to rollforward)
    > 3. do a REDIRECTED RESTORE (you can use the SET CONTAINERS script
    > create in the begining).
    >
    > I hope this helps....
    shashi b mannepalli Guest

  5. #5

    Default Re: restore into new db on in same instance...question

    Restore with redirect is always faster and requires less work. Because
    the Restore utility will go out and create the directory containers
    for you including the system tablespaces, if your user logon has all
    the proper permissions. For raw containers you do have to create them
    before hand. There is no advantage of creating a db just to be
    overwritten by another, except if default codepage on target system is
    different than codepage of the source database image.

    Powell


    [email]peter_sandstechemail.com[/email] (Peter Sands) wrote in message news:<6b009995.0307151028.2f6d35posting.google.co m>...
    > Hi,
    > I currently have a db (uw_db) using 30 DMS devices running on a
    > server. I want to create a copy of this db to ( uw_db_dev) on the same
    > server and instance.
    >
    > I extract (db2look) all the devices from the db uw_db , do a slight
    > name change to each device iwth in the output file and re-create them
    > taking the file as imput. Then do a restore db into newdb. WOuld I
    > have problems with the SMS for the temp user spaces ? if I did this
    >
    > Or would it be better to do a restore with redirect ?
    > Do to the amount of DMS devices I would rather automate as much as
    > possible.
    > Which option is best ?
    > thanks
    > pete
    Powell Guest

Similar Threads

  1. Trying to track an instance's position relative to the stage - instance is inside an MC
    By _posted.by\(Vern\); in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: January 20th, 04:52 AM
  2. Physical restore that doesn't require a logical restore
    By Christian Eriksson in forum Informix
    Replies: 6
    Last Post: September 24th, 11:30 AM
  3. Restore question AIX 4.3.3
    By Jan in forum AIX
    Replies: 1
    Last Post: July 30th, 11:31 AM
  4. Replies: 0
    Last Post: July 25th, 06:16 PM
  5. Replies: 3
    Last Post: July 18th, 07:47 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139