Re: Restores

I'm about to release a new version of myexport/myimport that uses EXTERNAL TABLES. The load runs over twice as fast as a run using sqlcmd. Since the default sqlcmd mode is about comparable to dbimport in speed which would also make it about twice as fast as dbimport. If you perform the exports and imports in parallel it MIGHT even compete with ontape! Haven't timed the exports yet. Anyone want to Beta test this release? Neil? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 24, 2010 at 7:24 AM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > > In this case, where a downgrade is needed, isn't exists a workaround from > IBM support ? > The client always need to export/import all databases? > Technical speaking , is WG already impose a hard limitation of resources > like partitioning ? what can be one reason to limit this restore... > > Neil, a suggestion to workaround... export all data in "binary" mode ("no > conversion" for HPL or "informix" for external tables) and use it to > reimport in your test/development environment or test if the onunload/onload > works , this way you don't need to recreate your indexes they are > exported/imported together with all data. > > --- Em *qua, 24/3/10, Art Kagel <art.kagel@gmail.com>* escreveu: > > > De: Art Kagel <art.kagel@gmail.com> > Assunto: Re: Restores > Para: "Neil Truby" <neil.truby@ardenta.com> > Cc: informix-list@iiug.org > Data: Quarta-feira, 24 de Março de 2010, 0:41 > > Granted and accepted. > > As far as the semantics, when hard core developers (I still count myself in > there) talk about the 'code base' we refer to the source code files. If two > executable entities are compiled from the same source files, they have the > same code base. > > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org <http://mc/compose?to=art@iiug.org>) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, implicitly, > or by inference. Neither do those opinions reflect those of other > individuals affiliated with any entity with which I am affiliated nor those > of the entities themselves. > > > > On Tue, Mar 23, 2010 at 11:18 PM, Neil Truby <neil.truby@ardenta.com<http://mc/compose?to=neil.truby@ardenta.com>; > > wrote: > >> "Art Kagel" <art.kagel@gmail.com<http://mc/compose?to=art.kagel@gmail.com>>; >> wrote in message >> news:mailman.46.1269395389.1071.informix-list@iiug.org... >> >> You've never heard of #DEFINE and #if DEFINED()? Same code, different >> >> compiles. That's how the resoruce limitations are implemented as well >> as >> >> the version checks. >> >> Maybe we're just arguing semantics? >> You have to download different software for WGE then for EE (I know, I've >> just wasted half an hour downloading and installing EE just so I can do >> the >> restore ;-)). >> Depending upon which you've download they do different things, like put >> out >> resource restriction messages, and in fact actually apply the >> restrictions. >> Since there's nothing on my (or your syste,) which the oninit program can >> query to decide whether you are an EE or WGE customer, the code *must* be >> different, even if very supericially, surely ...?! >> >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org <http://mc/compose?to=Informix-list@iiug.org>; >> http://www.iiug.org/mailman/listinfo/informix-list >> > > > -----Anexo incorporado----- > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org <http://mc/compose?to=Informix-list@iiug.org>; > http://www.iiug.org/mailman/listinfo/informix-list > > > ------------------------------ > Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/>- > Celebridades<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/celebridades/>- > Música<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/m%C3%BAsica/>- > Esportes<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yahoo.com/esportes/>; > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.51.1269433222.1071.informix-list@iiug.org... I'm about to release a new version of myexport/myimport that uses EXTERNAL TABLES. The load runs over twice as fast as a run using sqlcmd. Since the default sqlcmd mode is about comparable to dbimport in speed which would also make it about twice as fast as dbimport. If you perform the exports and imports in parallel it MIGHT even compete with ontape! Haven't timed the exports yet. >> Anyone want to Beta test this release? Neil? Yes, I have a 200g db that I need to migrate from one country to another. I was planning to use ontape but am happy to trial all-new myexport and compare times. thanks N