Re: Onload, the "fast" alternative

Posted in 2011

Summary

Neil Truby found onload very slow, taking 17 hours for about 100 GB on 11.5FC8W2GE to the same version, and also got 14 SQL -23103 code-set conversion errors. Superboer suggested checking physical logging with onstat -l and onstat -g iof, and noted onload cannot mix versions; Neil said versions matched. The slowness was not explained.

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

Topics: Migration, Import/Export & Data Conversion

Neil Truby — Thu, 17 Mar 2011 20:23:02 -0000 — source: Usenet: comp.databases.informix

"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

↪ replying to Neil Truby

Superboer — Fri, 18 Mar 2011 06:06:32 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to Superboer

Superboer — Fri, 18 Mar 2011 06:15:44 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to Superboer

Neil Truby — Fri, 18 Mar 2011 14:46:57 -0000 — source: Usenet: comp.databases.informix

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

Related threads

Glossary

onload / onunload