Re: Question regarding moving a database

John & Cassy Montgomery wrote: > > A software package I support uses Informix Online as it DBMS engine. We > often need to bring back customer databases to the lab to recreate and > debug problems. > Translation: We're hacking and are trying to figure out just what the files are that make up an Informix data base. > Our software as it is currently written prohibits the use of dbexport > and import as a way to move the database because certain type of data > are lost. Translation: Nobody in our company has a clue how to work with data bases. The last guy working on the application left for a higher paying position elsewhere. > We have been using ontape to backup and restore the customer > databases, but this is a bit of a pain the destination machine must > have >= the size of the raw partition and we do not alwys have the > original onconfig file or partition sizes. > Translation: No backup plan was ever instituted as we're in constant chaos. Somebody lost the last backup tape and now we gotta restore the data base. Hey could you pass me my coffee over here while I read this... > I was wondering if there is another way to do this? Will > onunload/onload work here? > Translation: Now where did he hide those Informix manuals? I tried rebooting the machine several times but this didn't work. > Another wrinkle is that sometimes customers have had new chunks added > since their original database partitions were getting full. Translation: Users are going ahead with their own versions of the software, and making many changes to the data base. We're on a short leash with the boss, it's only a matter of time. > They later > get a new faster machine and want to move their database and consolidate > their chunks back into the original arrangement. Translation: Our department is the laughing stock of our customer base and well, all we can do now is hope they don't buy somebody else's software. We'll end up supporting something else we don't know. > Can this be easily > done? > Translation: We can't find the manuals and are convinced the guy who was doing the dba work took them, and won't answer his pager. Maybe he has a cellphone number...hmmmm maybe if I do this... > Yours truly, yet another Informix neophyte...... > > -- > John & Cassy Montgomery email: montgomery@igs.net > Kanata, Ontario, Canada URL: http://www.igs.net/~montgomery Sorry, it was irresistable... Best of luck to you... :-) ( trying not to laugh too loud ) -- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) FL, USA, Earth -------------------------------oOOo---( )---o00o-------------------------------- http://www.mindspring.com/~tschaefe Liberty: http://www.lp.org Informix FAQ: http://www.iiug.org --------------------------------------------------------------------------------