Unix Technical Forum

Re: How to recover a data base

This is a discussion on Re: How to recover a data base within the Informix forums, part of the Database Server Software category; --> Hi, hmm. You want to get the database schema from the old system? Is that what you mean by ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 11:27 AM
Martin Fuerderer
 
Posts: n/a
Default Re: How to recover a data base

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:56 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com