Re: Onload, the "fast" alternative

"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.838.1300203605.1071.informix-list@iiug.org... >> Myexport/myimport using EXTERNAL TABLES in express mode in parallel will >> FLY! It should be faster then HPLoader even. Thanks. It looks good. However, I got 14 of this messag: SQL -23103: Code-set conversion function failed due to illegal sequence or invalid value .. which I assume means that the unloads of the relvant tables has failed. Back to the original question, does anyone know why onload is so slow? It eventually loaded the 100g-odd in SEVENTEEN hours! Thanks

Hello Neil, Did you check if stuff is physical logged ??? onstat -l during the load and maybe onstat -g iof etc. Superboer. On 17 mrt, 21:23, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Art Kagel" <art.ka...@gmail.com> wrote in message > > news:mailman.838.1300203605.1071.informix-list@iiug.org... > > >> Myexport/myimport using EXTERNAL TABLES in express mode in parallel will > >> FLY!  It should be faster then HPLoader even. > > Thanks.  It looks good.  However, I got 14 of this messag: > SQL -23103: Code-set conversion function failed due to illegal sequence or > invalid value > > .. which I assume means that the unloads of the relvant tables has failed. > > Back to the original question, does anyone know why onload is so slow?  It > eventually loaded the 100g-odd in SEVENTEEN hours! > > Thanks

OOOppss i missed AFAIK you cannot use onunload/onload for differ IFX versions... from Cesar and he is right!!! you can not mix. Superboer. On 18 mrt, 14:06, Superboer <superbo...@t-online.de> wrote: > Hello Neil, > > Did you check if stuff is physical logged ??? > > onstat -l during the load and maybe onstat -g iof etc.> > Superboer. > > On 17 mrt, 21:23, "Neil Truby" <neil.tr...@ardenta.com> wrote: > > > "Art Kagel" <art.ka...@gmail.com> wrote in message > > >news:mailman.838.1300203605.1071.informix-list@iiug.org... > > > >> Myexport/myimport using EXTERNAL TABLES in express mode in parallel will > > >> FLY!  It should be faster then HPLoader even. > > > Thanks.  It looks good.  However, I got 14 of this messag: > > SQL -23103: Code-set conversion function failed due to illegal sequence or > > invalid value > > > .. which I assume means that the unloads of the relvant tables has failed. > > > Back to the original question, does anyone know why onload is so slow?  It > > eventually loaded the 100g-odd in SEVENTEEN hours! > > > Thanks

Yeah, I'm not trying to. This is 11.5FC8W2GE -> 11.5FC8W2GE Thanks "Superboer" <superboer7@t-online.de> wrote in message news:8c2c42f6-bb47-43ae-9b1c-96097f56b597@x1g2000yqb.googlegroups.com... OOOppss i missed AFAIK you cannot use onunload/onload for differ IFX versions... from Cesar and he is right!!! you can not mix. Superboer. On 18 mrt, 14:06, Superboer <superbo...@t-online.de> wrote: > Hello Neil, > > Did you check if stuff is physical logged ??? > > onstat -l during the load and maybe onstat -g iof etc.> > Superboer. > > On 17 mrt, 21:23, "Neil Truby" <neil.tr...@ardenta.com> wrote: > > > "Art Kagel" <art.ka...@gmail.com> wrote in message > > >news:mailman.838.1300203605.1071.informix-list@iiug.org... > > > >> Myexport/myimport using EXTERNAL TABLES in express mode in parallel > > >> will > > >> FLY! It should be faster then HPLoader even. > > > Thanks. It looks good. However, I got 14 of this messag: > > SQL -23103: Code-set conversion function failed due to illegal sequence > > or > > invalid value > > > .. which I assume means that the unloads of the relvant tables has > > failed. > > > Back to the original question, does anyone know why onload is so slow? > > It > > eventually loaded the 100g-odd in SEVENTEEN hours! > > > Thanks