Home > Databases > Cloning a DB2 Linux and Unix Database using Redirected Restore

Cloning a DB2 Linux and Unix Database using Redirected Restore

  Submitted by Frank Databases 1 Comment

Ever wanted to clone your database for testing? This article gives
you the basics of cloning DB2 database for Linux and UNIX Operating System.

About The Author

Eugenia Loli

Ex-programmer, ex-editor in chief at OSNews.com, now a visual artist/filmmaker.

Follow me on Twitter @EugeniaLoli

One Response

  1. 2002-11-13 6:19 am
    Anonymous

    Reading articles like that reminds me why I use Sybase ASE.

    A whole article to explain how to backup a database and restore it onto another server?

    It should be 4 commands.

    sql: dump database prod to ‘/path/to/dump’

    sh : rcp /path/to/dump dev:/whatever/path/you/want

    sql: load database dev from ‘/whatever/path/you/want’

    sql: online database dev

    All done.

    Thankyou.

    (I will concede that managing the users across servers can be painful though)