Re: dbexport across multiple tapes

Irwin Goldstein wrote: > > Sorry for the previous empty posting... > > Does anyone know if dbexport and dbimport support exports/imports which > span multiple tapes? I have a database which is too large to fit on a single > tape which I wish to move from one machine to another. Yes, dbexport and dbimport work with multiple tapes. > Can this be done with > dbexport/dbimport? Can anyone suggest other and/or better ways to do this? I'd to > minimize downtime. The two machines will differ greatly in disk configuration (this > is part of the reason for the move) so ontape/onarchive do not seem to be alternatives. > We have down similar tasks many times. The quickest way is to do "insert select" (a single SQL statement) to remotely copy your database. There are other things to consider. For example, will the "insert select" statement become a long transaction? But they should be solvable. Chao