How to recover a data base

Hello I have a problem. There was an informix data base, whose files were copied before the pc was formated. That is, any export was done. Now I have created a new informix data base, and I want to recover the structure from the old data base. How can I do that? Thanx

Hi, hmm. You want to get the database schema from the old system? Is that what you mean by "structure" ? You don't want the actual data? Basically you have to bring back to life the old system, then you can run the utility "dbschema" using the option "-ss" to get the database schemas of the old system. "-ss" means that the utility will also output system specific information (like table extent sizes, dbspace names, etc.). To bring back to life the old system you have to place the "chunks" at the same location (with the same path name) where they were before, use the "onconfig" configuration file and the server name (environment variable $INFORMIXSERVER, see SERVERNAME in the old onconfig file) from the old system, together with a corresponding entry in the sqlhosts file. With that you should be able to start the system (by executing "oninit" without any option), so that you then can run the "dbschema" utility. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management informix-list-bounces@iiug.org wrote on 03.02.2006 15:59:19: > Hello > I have a problem. There was an informix data base, whose files were > copied before the pc was formated. That is, any export was done. Now I > have created a new informix data base, and I want to recover the > structure from the old data base. How can I do that? > Thanx > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list