Recovering database from dbspaces

Hi, I have dbspaces(root, data and log) of an instance. I want to recover the database from these physical files on some other machine having same OS and hardware. Is there any way to get it done? Thanks, Anees

If and only if the engine that wrote them was properly shut down, and you can get either the same version of Informix or one that is sufficiently close that an in-place upgrade of the dbspaces is possible, then yes. Just copy the chunk files or devices to files or devices on the other machine, recreate the original paths, create an ONCONFIG file and sqlhosts file substantially similar to the original server's ONCONFIG and sqlhosts files, and start the engine with 'oninit -v'. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Apr 5, 2011 at 8:32 AM, ANEES AHMAD <aanees@i2cinc.com> wrote: > Hi, > > I have dbspaces(root, data and log) of an instance. I want to recover the > database from these physical files on some other machine having same OS and > hardware. > Is there any way to get it done? > > Thanks, > Anees > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec53f91dd7e7f0b04a02b90dd