Ever wanted to clone your database for testing? This article gives
you the basics of cloning DB2 database for Linux and UNIX Operating System.
Cloning a DB2 Linux and Unix Database using Redirected Restore
About The Author
Eugenia Loli
Ex-programmer, ex-editor in chief at OSNews.com, now a visual artist/filmmaker.
Follow me on Twitter @EugeniaLoli
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)