Re: Restores

On 24 Mar, 12:19, Art Kagel <art.ka...@gmail.com> wrote: > 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 (a...@iiug.org) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KSwww.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_mart...@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.ka...@gmail.com>* escreveu: > > > De: Art Kagel <art.ka...@gmail.com> > > Assunto: Re: Restores > > Para: "Neil Truby" <neil.tr...@ardenta.com> > > Cc: informix-l...@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 (a...@iiug.org <http://mc/compose?to=...@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.tr...@ardenta.com<http://mc/compose?to=neil.tr...@ardenta.com>; > > > wrote: > > >> "Art Kagel" <art.ka...@gmail.com<http://mc/compose?to=art.ka...@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-l...@iiug.org <http://mc/compose?to=Informix-l...@iiug.org>; > >>http://www.iiug.org/mailman/listinfo/informix-list > > > -----Anexo incorporado----- > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org <http://mc/compose?to=Informix-l...@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.yah...>- > > Celebridades<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yah...>- > > Música<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yah...>- > > Esportes<http://br.rd.yahoo.com/mail/taglines/mail/*http://br.maisbuscados.yah...>; > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list I'll beta test it, email me at davidmsdw@yahoo.co.uk