Oninit cdi / Archive
Talk to an expert →

Re: Setting up copy on y2k test machine

Posted in 1999

Summary

Surfer! planned to copy an OnLine database to a test machine for y2k testing by dbexport/dbimport and asked whether a level 0 archive could be used instead. Neil Truby said a level 0 archive and restore works if the test server uses exactly the same path names as live, clarifying that this means chunks. John Carlson reported doing this routinely with identical logical layouts: one restore took 4 hours, much faster than dbexport/dbimport. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

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