RE: load from xxx fails

> At about 53000 rows on the reload, the load dies with an error "corrupted > load file" or somesuch. When we do a split on the load file using Unix > "split -45000 loadfile" and load from the pieces, all rows come in properly > with no errors, so it's not bad data. When we try deleting several hundred > rows around the death point and reloading, it dies again (on the full-size - > several hundred rows file). Looks like some sort of a file size problem, but > the unloaded file comes out fine. Tbcheck has no problem with the file or > with the indexes. > jlumbley@netcom.com (Joe Lumbley) We had a similar problem with Online 5.01 on RS-6000 550. I determined the problem to be the number of lock files in informix. Basically it appeared that each row was getting a lock. I did not try locking the table, since once it was loaded we were done. Rick Tucker (616)457-8873 Independent Consulting Services rickt%indcon@wybbs.mi.org uunet!4gen!indcon!rickt