Results 1 to 5 of 5

Thread: Backup database

  1. #1
    Join Date
    Jan 2004
    Posts
    50

    Unanswered: Backup database

    Hi all,
    I 'd like to create a database from backup image, please tell how can i do it?
    Thanks

  2. #2
    Join Date
    Dec 2003
    Posts
    454

    store images

    I'm not clear to your question. Do you want to create a new database to store the images?

  3. #3
    Join Date
    Jan 2004
    Posts
    50

    Re: store images

    i mean that i 'd like to create a new database from backup image, please help me.
    Thanks



    Originally posted by gyuan
    I'm not clear to your question. Do you want to create a new database to store the images?

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Restore Command

    Hi,

    Try this

    db2 restore database <database name> from <backup-bath> to <new-location> into <new-alias>.

    for e.g.

    db2 restore database test from e:\db2bk to d: into newtest.

    please check the restore command syntax for more details.

    Cheers

    Nitin
    HTH

    Nitin

    Ask the experienced rather than the learned

  5. #5
    Join Date
    Mar 2003
    Posts
    343
    You need to do a redirected restore.

    The sequence of events would be

    restore database <source-dbname>
    from/load <depending on where the backup is>
    taken at <backup date and time>
    to <target db directory>
    into <target dbname>
    newlogpath <target db logpath>
    with <num buffers that source backup was taken with> buffers
    buffer <buffer size that source backup was taken with>
    redirect

    You will have to know what the source db tablespaces were.

    At this point, for every tablespace in the source database, the following must be issued
    set tablespace containers for <tbspace id in src db>
    using <sms or dms container path>

    restore db <source dbname> continue

    If this is an MPP system , this will have to be done for each node starting with the catalog node.

    Hope this helps.

Posting Permissions

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