Re: Best method for moving a database

I think the easiest way is to use onunload/onload (and you don't need to create the database/tables before using onload). All you have to do is: onunload -t tape_device database_namethen drop the database and: onload -t tape_device -d dbspacename database_name As tape device you can use a file (just make sure that file exists before running onunload). In this case your database size should be less than 2Gb (on most systems). Best Regards, Octav On Thu, Mar 18, 1999 at 10:28:02AM -0000, Tony Flaherty wrote: > Hi, > > I'm reorganising my system, creating new dbspaces and moving the > databases. > > What's the most efficient way of doing this? I have to drop all of the > existing dbspaces prior to creating the new ones. I was planning on using > dbexport/dbimport but I do have a back-up machine, so I could create the > schema for the databases in the new dbspaces and then use sql scripts to > load the databases across the network from the copies on the back-up > machine. Hope this makes sense! > > Also, I could use onunload, if I do, do I need to create the database/tables > before using onload? > > I guess whatever I do I need to turn off logging for the databases to > prevent long transaction and out of locks errors. One or two of the > transaction tables have aprox. 500,000 rows. > > The biggest database is about 600Mb according to the tbl_usage prog. > downloaded form the IIUG. > > HP-UX 10.20 > Online 7.24.UC5 > > > Thanks, > Please no RTFM replies, I am, but this is a screw it up and get a job > somewhere else event and I kinda want to be sure I know what I'm doing. > That's why I'm inclined to use dbimport, its what I know. > > --------------------------------------- > Tony Flaherty aef@mfs.misys.co.uk > Analyst Programmer > Misys Financial Systems > All statements and opinions are my own, > Misys don't pay me enough to have opinions > on their behalf > > . > > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com