Question about export/inport

Greetings, Although this is probably a simple question, I'm not sure start and am looking for pointers. Although my experience is mostly with Oracle, I am working at a client who has an Informix database (7.3). I am helping them add redundancy and fail-over. The database is small (<50 MB) and reasonably static (some changes every day, although through administrative changes, not user initiated). What I want to do is periodically (perhaps nightly, or maybe several times during the day) export the contents of the "master" database, and restore that database on a "backup" database. The intent is that if the master database ever crashes, we can easily point the application to use the backup database. My question is how do I export / import on Informix 7.3 IDS? Would I use some syntax of the onbar, which looks like it wants to write to tape? Or is there some other utility that I should be looking at? Sorry for the newbie question, but I haven't had much experience with Informix, and am looking for the right place to start. With Oracle, I have written scripts that export / FTP / import automatically, when faced with similar environments. Thanks, Dave. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= = David E. Filip | Email: dfilip@colornet.com = = ColorNet Information Systems | WWW : http://www.colornet.com = =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

hi, are "master" and "backup" on the same maschine? if not, easiest way is to do an "ontape" to a file, ftp to the "backup" maschine and overwrite its database with ontape that's only ONE possiblity (dbexport/import, datareplication... ) chris "David E. Filip" wrote: > Greetings, > > Although this is probably a simple question, I'm not sure start and am looking > for pointers. > > Although my experience is mostly with Oracle, I am working at a client who > has an Informix database (7.3). I am helping them add redundancy and > fail-over. The database is small (<50 MB) and reasonably static (some changes > every day, although through administrative changes, not user initiated). > > What I want to do is periodically (perhaps nightly, or maybe several times > during the day) export the contents of the "master" database, and restore > that database on a "backup" database. The intent is that if the master > database ever crashes, we can easily point the application to use the > backup database. > > My question is how do I export / import on Informix 7.3 IDS? > > Would I use some syntax of the onbar, which looks like it wants to > write to tape? Or is there some other utility that I should be looking at? > > Sorry for the newbie question, but I haven't had much experience with > Informix, and am looking for the right place to start. With Oracle, I > have written scripts that export / FTP / import automatically, when faced > with similar environments. > > Thanks, > > Dave. > > -- > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > = David E. Filip | Email: dfilip@colornet.com = > = ColorNet Information Systems | WWW : http://www.colornet.com = > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

On Fri, 1 Sep 2000 06:19:36 +0100 , chris <cwalz@mayn.de> wrote: >hi, >are "master" and "backup" on the same maschine? >if not, easiest way is to do an "ontape" to a file, ftp to the "backup" maschine >and overwrite its database with ontape >that's only ONE possiblity (dbexport/import, datareplication... ) >chris However you will have to set up the db on the second machine so that all the symbolic names of the dbspaces & chunks are identical and they are at least as large as on the source machine. > > >"David E. Filip" wrote: > >> Greetings, >> >> Although this is probably a simple question, I'm not sure start and am looking >> for pointers. >> >> Although my experience is mostly with Oracle, I am working at a client who >> has an Informix database (7.3). I am helping them add redundancy and >> fail-over. The database is small (<50 MB) and reasonably static (some changes >> every day, although through administrative changes, not user initiated). >> >> What I want to do is periodically (perhaps nightly, or maybe several times >> during the day) export the contents of the "master" database, and restore >> that database on a "backup" database. The intent is that if the master >> database ever crashes, we can easily point the application to use the >> backup database. >> >> My question is how do I export / import on Informix 7.3 IDS? >> >> Would I use some syntax of the onbar, which looks like it wants to >> write to tape? Or is there some other utility that I should be looking at? >> >> Sorry for the newbie question, but I haven't had much experience with >> Informix, and am looking for the right place to start. With Oracle, I >> have written scripts that export / FTP / import automatically, when faced >> with similar environments. >> >> Thanks, >> >> Dave. >> >> -- >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >> = David E. Filip | Email: dfilip@colornet.com = >> = ColorNet Information Systems | WWW : http://www.colornet.com = >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

If it's really that small, and there's negligible user input ... can you not mirror the databases? I remember doing that about three/four years ago between London and Leeds using online - but have no access to the appropriate manuals now, so can not give you the syntax. * Art or Jonathan, help here * You still need tape backups for security "Sally Woolrich" <sally.woolrich@comino.com> wrote in message news:39af7298.235070303@comino-leeds... > On Fri, 1 Sep 2000 06:19:36 +0100 , chris <cwalz@mayn.de> wrote: > > >hi, > >are "master" and "backup" on the same maschine? > >if not, easiest way is to do an "ontape" to a file, ftp to the "backup" maschine > >and overwrite its database with ontape > >that's only ONE possiblity (dbexport/import, datareplication... ) > >chris > > However you will have to set up the db on the second machine so that > all the symbolic names of the dbspaces & chunks are identical and they > are at least as large as on the source machine. > > > > > > >"David E. Filip" wrote: > > > >> Greetings, > >> > >> Although this is probably a simple question, I'm not sure start and am looking > >> for pointers. > >> > >> Although my experience is mostly with Oracle, I am working at a client who > >> has an Informix database (7.3). I am helping them add redundancy and > >> fail-over. The database is small (<50 MB) and reasonably static (some changes > >> every day, although through administrative changes, not user initiated). > >> > >> What I want to do is periodically (perhaps nightly, or maybe several times > >> during the day) export the contents of the "master" database, and restore > >> that database on a "backup" database. The intent is that if the master > >> database ever crashes, we can easily point the application to use the > >> backup database. > >> > >> My question is how do I export / import on Informix 7.3 IDS? > >> > >> Would I use some syntax of the onbar, which looks like it wants to > >> write to tape? Or is there some other utility that I should be looking at? > >> > >> Sorry for the newbie question, but I haven't had much experience with > >> Informix, and am looking for the right place to start. With Oracle, I > >> have written scripts that export / FTP / import automatically, when faced > >> with similar environments. > >> > >> Thanks, > >> > >> Dave. > >> > >> -- > >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- = > >> = David E. Filip | Email: dfilip@colornet.com = > >> = ColorNet Information Systems | WWW : http://www.colornet.com = > >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- = >

Sally's right, as you say your database is only 50Mb then I'd opt for dbimport. So Sally, still at Excelsis? Tony Flaherty, Snr A/P, DBA, Unix Admin, GDB Misys Financial Systems Sally Woolrich wrote in message <39af7298.235070303@comino-leeds>... >On Fri, 1 Sep 2000 06:19:36 +0100 , chris <cwalz@mayn.de> wrote: > >>hi, >>are "master" and "backup" on the same maschine? >>if not, easiest way is to do an "ontape" to a file, ftp to the "backup" maschine >>and overwrite its database with ontape >>that's only ONE possiblity (dbexport/import, datareplication... ) >>chris > >However you will have to set up the db on the second machine so that >all the symbolic names of the dbspaces & chunks are identical and they >are at least as large as on the source machine. > >> >> >>"David E. Filip" wrote: >> >>> Greetings, >>> >>> Although this is probably a simple question, I'm not sure start and am looking >>> for pointers. >>> >>> Although my experience is mostly with Oracle, I am working at a client who >>> has an Informix database (7.3). I am helping them add redundancy and >>> fail-over. The database is small (<50 MB) and reasonably static (some changes >>> every day, although through administrative changes, not user initiated). >>> >>> What I want to do is periodically (perhaps nightly, or maybe several times >>> during the day) export the contents of the "master" database, and restore >>> that database on a "backup" database. The intent is that if the master >>> database ever crashes, we can easily point the application to use the >>> backup database. >>> >>> My question is how do I export / import on Informix 7.3 IDS? >>> >>> Would I use some syntax of the onbar, which looks like it wants to >>> write to tape? Or is there some other utility that I should be looking at? >>> >>> Sorry for the newbie question, but I haven't had much experience with >>> Informix, and am looking for the right place to start. With Oracle, I >>> have written scripts that export / FTP / import automatically, when faced >>> with similar environments. >>> >>> Thanks, >>> >>> Dave. >>> >>> -- >>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- = >>> = David E. Filip | Email: dfilip@colornet.com = >>> = ColorNet Information Systems | WWW : http://www.colornet.com = >>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- = >

In article <8oml66$j8j$1@hudson.dti.net>, dfilip@colornet.com (David E. Filip) wrote: > Greetings, > > Although this is probably a simple question, I'm not sure start and am looking > for pointers. > > Although my experience is mostly with Oracle, I am working at a client who > has an Informix database (7.3). I am helping them add redundancy and > fail-over. The database is small (<50 MB) and reasonably static (some changes > every day, although through administrative changes, not user initiated). > > What I want to do is periodically (perhaps nightly, or maybe several times > during the day) export the contents of the "master" database, and restore > that database on a "backup" database. The intent is that if the master > database ever crashes, we can easily point the application to use the > backup database. > > My question is how do I export / import on Informix 7.3 IDS? > > Would I use some syntax of the onbar, which looks like it wants to > write to tape? Or is there some other utility that I should be looking at? > > Sorry for the newbie question, but I haven't had much experience with > Informix, and am looking for the right place to start. With Oracle, I > have written scripts that export / FTP / import automatically, when faced > with similar environments. > > Thanks, > > Dave. > > -- > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-= > = David E. Filip | Email: dfilip@colornet.com = > = ColorNet Information Systems | WWW : http://www.colornet.com = > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-= > You might want to look at HDR (High Availability Data Replication). Chapters 25-26 (??) in the Informix Administrators Guide. Much better than similar replication (or "standy") setups in Oracle. A.J.Andrews Sent via Deja.com http://www.deja.com/ Before you buy.

I think youre are looking for dbexport/dbimport in comparison to exp/imp of oracle. It too exports the whole database Including scheme and data. It seems to me that you want install replication on a mini DB (<50) MB with minimum effort. Unlike Oracle exp/imp(One File), dbexport creates a Directory with the scheme file and a file for every table.(keep in mind by using ftp) To import the database again, you have to drop it first. (of course) usage 'dbexport -ss yourdatabase' creates the directory yourdatabase.exp with all files in it. -ss is for compressing extents. 'dbimport yourdatabase' imports the Data from this Directory ( Ifx - SQL-Statement: 'drop database yourdatabase' ) ( Ora-SQL-Statement: 'drop user Youruser cacscade' ); HTH Cris On 31 Aug 2000 22:11:18 GMT, dfilip@colornet.com (David E. Filip) wrote: >Greetings, > >Although this is probably a simple question, I'm not sure start and am looking >for pointers. > >Although my experience is mostly with Oracle, I am working at a client who >has an Informix database (7.3). I am helping them add redundancy and >fail-over. The database is small (<50 MB) and reasonably static (some changes >every day, although through administrative changes, not user initiated). > >What I want to do is periodically (perhaps nightly, or maybe several times >during the day) export the contents of the "master" database, and restore >that database on a "backup" database. The intent is that if the master >database ever crashes, we can easily point the application to use the >backup database. > >My question is how do I export / import on Informix 7.3 IDS? > >Would I use some syntax of the onbar, which looks like it wants to >write to tape? Or is there some other utility that I should be looking at? > >Sorry for the newbie question, but I haven't had much experience with >Informix, and am looking for the right place to start. With Oracle, I >have written scripts that export / FTP / import automatically, when faced >with similar environments. > >Thanks, > >Dave. > >-- >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >= David E. Filip | Email: dfilip@colornet.com = >= ColorNet Information Systems | WWW : http://www.colornet.com = >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=