Re: Restores

Sorry, I send the message before finish... this is the complete message.. I don't know if the onunload/onload have the same version limitation of ontape, did you tested it? AFAIK they works in a similar way from ontape, dumping the used pages and the structure of the table/indexes... what is very fast, just like the ontape. And with it , you can specify to export the database in single command to unique file... Just remember, the destination must have the same dbspaces configuration... and if your company buy the WG after  feb/2009 and yours tables use partitioning , you will violate a license limitation on the WG (what don't permits partitioning), in this case, you don't have any choice.. must export/import... --- Em qua, 24/3/10, Neil Truby <neil.truby@ardenta.com> escreveu: De: Neil Truby <neil.truby@ardenta.com> Assunto: Re: Restores Para: informix-list@iiug.org Data: Quarta-feira, 24 de Março de 2010, 9:27 "Cesar Inacio Martins" <cesar_inacio_martins@yahoo.com.br> wrote in message news:mailman.50.1269429864.1071.informix-list@iiug.org... >> 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. Hi Cesar Thanks for the suggestion. There is indeed the possibility to do ASCII transfers for modest data volumes. The larger the db though the more attractive the archive/restore option In this case I am investigating a performance issue that may be a function of how the data physically exists on disk, so an archive/restore is the only option. regards _______________________________________________ Informix-list mailing list 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 - Celebridades - Música - Esportes ____________________________________________________________________________________ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com