OnLine 7.1UD1 bugs on DEC Alpha

A while back we discovered a problem with using OnLine 7.1uC1 on the DEC Alpha platform running OSF/1 v3.0. Now the problem continues, despite Tech Support's claims that it wouldn't! We are now using DEC OSF/1 v3.2 Informix Online v7.1 UD1. Briefly, here's a repost, with updated comments. When running an update of the form: UPDATE table SET attribute = value WHERE attribute = whatever the engine will update only 129 rows, regardless of how many there are that meet the criterion. Worse, it reports a success status. (We have some paranoid code that checked the number of rows, and found that the number to update did not match the number updated.) This only happens when there is an index on 'attribute', and there is a WHERE clause used. Informix support could not reproduce the error on a Sun machine, maybe it only happens on DEC Alphas. (This has since been sort of confirmed, on an AIX box.) We are (still) waiting on a patch, or something, this "challenge" has been assigned problem number Group4, Bug6, #38789. In the meantime, we are writing more cautious code to check things like this by checking the number of rows left to process until the number is zero. Also, there are other bugs: The installonline script will not run as documented. We had to use: sh -x installonline. And (bug number 26505) defining the PSORT, or DBTEMP variables doesn't affect where the temp sort files are built when running oncheck -cI. (So it fills up our disk!) And we must press escape twice after the first time when running ISQL. We're on the phone with Informix, but then again we've been there since April. This is just to warn anyone who might be in the same boat but not know it. __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|