Restoring a dataspace

Hi, I have two identical database installations in two identical machines. Is it possible restore one dbspace from one machine to another with ontape? I'd like to load a database to this dbspace in one machine and then move it over to another machine afterwards. Thank you for any help HFS

Hi, no, you cannot restore a backup of one dbspace from one machine as a dbspace onto another machine to another IDS instance. As you want to only restore a specific dbspace I assume that this is not a critical dbspace (i.e. not root dbspace or one containing logs). As such this would be a warm restore of that dbspace. You can do a cold restore of a backup from one system/machine to another system/machine. But as this is a cold restore you would have to restore also root dbspace, etc. This in effect will overwrite the existing IDS instance (especially all its data) on the target machine. But if I understand it correctly, this is not what you want. I think you have to look into export/import or unload/load methods. There is dbexport/dbimport and High Performance Loader. Besides there is unload/load (SQL statenments) and possibly the use of the onunload/onload utilities (the last I'm not 100% sure in your case). But also make sure to look at Art Kagel's utility suite! There is some useful help for export and import of data! :) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Dirk Wittkopp Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 informix-list-bounces@iiug.org wrote on 12/17/2009 09:16:12 AM: > [image removed] > > Restoring a dataspace > > HFS > > to: > > informix-list > > 12/17/2009 09:20 AM > > Sent by: > > informix-list-bounces@iiug.org > > Hi, > > I have two identical database installations in two identical machines. > Is it possible restore one dbspace from one machine to another with > ontape? I'd like to load a database to this dbspace in one machine and > then move it over to another machine afterwards. > > Thank you for any help > HFS > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list