Re: onload Informix 7.14 / pyramid bugs?

hause011@maroon.tc.umn.edu (Steven Hauser) wrote: >machine: Pyramid SMP_DC.OSx 1.1-94d079 dcosx NILE 16/1536 r4400 (16 cpu) > >Informix: Version 7.14.UD2 > >Problem: onunload, onload problem with named pipe: > Error reading buffer > Error no. 32 broken pipe. > >The onload utility will have a repeatable problem unloading and loading the >same pages on the same few tables in a 5 GB database. The rest of the tables >will load, one onload per table at a time. oncheck gives no errors for the >instances or databases. > >Is this a known bug? I can't tell you if the above is a recognized bug by Informix, but the entire tb/on[un]load family has been a problem for me since 4.1, through the 5.x releases, and now under 7.1x. on Pyramid MIS-T, S, and Nile servers. I have never had good luck with these programs, and now I avoid them when I can. Here is a list of things to try (which you might have already done): You didn't list table sizes, or what kind of data the problem tables contained, but if you can, you might try dbexport / dbimport (or just a simple unload / drop / create/ reload). If you have the space, you could also try copying the content of the table to another table that you create from scratch, and then onunload the copy, and try to onload it back. If you can turn logging off, you can copy the table with a insert into/select from combo. Good luck. .......................................................................... Erik Jones - Anasazi Inc. - erik@anasazi.com