Is there a generic way to copy an entire database from one machine to another? I am developing an application that I test against a number of logically identical databases on different UNIXes (AIX, SunOS, HP-UX, Linux etc), and creating the sample database + loading test data with the tools provided from a third party takes about 30 hours, so I would prefer to do that only once, if possible. Any suggestions?

Maybe, you should read this page on 'Using Different Operating Systems' in V8 docs

http://publib.boulder.ibm.com/infoce...n/c0005960.htm


I don't have the infrastructure to test it, but looks like with most flavours of Unix (except Linux), you should be able to backup-resotre ..

I remember reading sometime back, that backup-resotre withing big-endian unix platforms is supported



HTH

Sathyaram

Thanks! It seems that db2move is what I want here.