Oninit cdi / Archive
Talk to an expert →

Re: Setting up copy on y2k test machine

Posted in 1999

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion

Neil Truby — — source: Informix-list mailing list archive (1991-1998)

Provided you set up your test Informix server with exactly the same path names as those of the live, you can use a level 0 archive and restore. This could, depending upon the size of your database server, save you a lot of time. Neil Surfer! wrote in message <3V38HHAAxlD3EwKW@nevis-view.demon.co.uk>... > >I will be setting up a copy of an Online database & programs for y2k >testing. My thoughts on how to do this are to establish an Online >instance on that machine, and set up the dbspaces needed as per the >current database. Then we dbexport the live & dbimport into the test. >Any better ideas out there - for example is there something we can do >with a level 0 archive? They do one of those every day. > >Surfer! >URL: http://www.nevis-vieww.demon.co.uk >Email: surfer@nevis-vieww.demon.co.uk >Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.

↪ replying to Neil Truby
Surfer! — — source: Informix-list mailing list archive (1991-1998)

In article <7elpt1$isv$1@taliesin.netcom.net.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Provided you set up your test Informix server with exactly the same path >names as those of the live, Presumably meaning for the dbspaces. This may be possible! > you can use a level 0 archive and restore. This >could, depending upon the size of your database server, save you a lot of >time. > >Neil >Surfer! wrote in message <3V38HHAAxlD3EwKW@nevis-view.demon.co.uk>... >> >>I will be setting up a copy of an Online database & programs for y2k >>testing. My thoughts on how to do this are to establish an Online >>instance on that machine, and set up the dbspaces needed as per the >>current database. Then we dbexport the live & dbimport into the test. >>Any better ideas out there - for example is there something we can do >>with a level 0 archive? They do one of those every day. >> >>Surfer! >>URL: http://www.nevis-vieww.demon.co.uk >>Email: surfer@nevis-vieww.demon.co.uk >>Hopeful anti-spam: alter double 'w' to single 'w' to view site & send >Email. > > Surfer! URL: http://www.nevis-vieww.demon.co.uk Email: surfer@nevis-vieww.demon.co.uk Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.

↪ replying to Surfer!
Carlson@WHSmith — — source: Informix-list mailing list archive (1991-1998)

We do it all the time. Our logical layouts are identical between our test and production system. One level 0 restore of production to test -- 4 hours. Much faster than dbexport/dbimport. John Carlson Informix DBA WHSmith USA Surfer! wrote: > > In article <7elpt1$isv$1@taliesin.netcom.net.uk>, Neil Truby > <ntruby@netcomuk.co.uk> writes > >Provided you set up your test Informix server with exactly the same path > >names as those of the live, > > Presumably meaning for the dbspaces. This may be possible! > > > you can use a level 0 archive and restore. This > >could, depending upon the size of your database server, save you a lot of > >time. > > > >Neil > >Surfer! wrote in message <3V38HHAAxlD3EwKW@nevis-view.demon.co.uk>... > >> > >>I will be setting up a copy of an Online database & programs for y2k > >>testing. My thoughts on how to do this are to establish an Online > >>instance on that machine, and set up the dbspaces needed as per the > >>current database. Then we dbexport the live & dbimport into the test. > >>Any better ideas out there - for example is there something we can do > >>with a level 0 archive? They do one of those every day. > >> > >>Surfer! > >>URL: http://www.nevis-vieww.demon.co.uk > >>Email: surfer@nevis-vieww.demon.co.uk > >>Hopeful anti-spam: alter double 'w' to single 'w' to view site & send > >Email. > > > > > > Surfer! > URL: http://www.nevis-vieww.demon.co.uk > Email: surfer@nevis-vieww.demon.co.uk > Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.

↪ replying to Surfer!
Neil Truby — — source: Informix-list mailing list archive (1991-1998)

Well, chunks actually. Neil Surfer! wrote in message ... >In article <7elpt1$isv$1@taliesin.netcom.net.uk>, Neil Truby ><ntruby@netcomuk.co.uk> writes >>Provided you set up your test Informix server with exactly the same path >>names as those of the live, > >Presumably meaning for the dbspaces. This may be possible! > > >> you can use a level 0 archive and restore. This >>could, depending upon the size of your database server, save you a lot of >>time. >> >>Neil >>Surfer! wrote in message <3V38HHAAxlD3EwKW@nevis-view.demon.co.uk>... >>> >>>I will be setting up a copy of an Online database & programs for y2k >>>testing. My thoughts on how to do this are to establish an Online >>>instance on that machine, and set up the dbspaces needed as per the >>>current database. Then we dbexport the live & dbimport into the test. >>>Any better ideas out there - for example is there something we can do >>>with a level 0 archive? They do one of those every day. >>> >>>Surfer! >>>URL: http://www.nevis-vieww.demon.co.uk >>>Email: surfer@nevis-vieww.demon.co.uk >>>Hopeful anti-spam: alter double 'w' to single 'w' to view site & send >>Email. >> >> > >Surfer! >URL: http://www.nevis-vieww.demon.co.uk >Email: surfer@nevis-vieww.demon.co.uk >Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.

Glossary