Large UPDATE crashes (ISAM error -121)

Path: emory!wupost!think.com!mips!mips!munnari.oz.au!deakin.OZ.AU!rand!auzodt3!shaneb From: shaneb@auzodt3.mel.cocam.oz.au (Shane Booth) Newsgroups: comp.databases.informix Message-ID: <953@rand.mel.cocam.oz.au> Date: 6 Mar 92 06:31:09 GMT Sender: usenet@rand.mel.cocam.oz.au Organization: Co-Cam Computer Group, Oz I have often had a problem with UPDATE's on tables with large numbers of rows where you wish to change a fair proportion of the records. This morning, I had a 12000 row database, each row is 224 bytes in size. I tried to update ~8000 of these rows in a single UPDATE, and isql came back with ISAM error -121: Cannot write to transaction log Three questions: 1) Has anyone had this problem before? 2) Why does isql have a problem with these large UPDATE's? 3) Is there any way to get around the problem without a) doing 50 small UPDATE's instead, or b) going to On-line? I have run this using version 4.00 on a SCO-Unix box. Thanks, -- Shane Booth: shaneb@auzodt3.mel.cocam.oz.au Co-Cam Computer Group, Abbotsford, Vic.