Re: Internal Limits - Are there any?

Bob Peirce writes: > Suddenly we are running into a problem updating a table. We run release > 2.10.00 on an Altos 3068. The table has about 1020 records and we have > never had a problem before. Unfortunately, since we never had a problem > before we have no idea how many records were in the table or how many > were being updated. We do know there were less than are there now but > we have no idea how many less. ... > However, we > think it is pretty clear we are running into some kind of internal > limit. I've never run into this, but here are a few ideas: What error message (if any) are you getting? This could help us distinguish several possibilities. For instance, it's conceivable that you're running out of temporary file space, in which case you could fix it just by emptying out /tmp, or by using a different partition by setting DBTMP. If it's really a limit internal to INFORMIX, you may be stuck, but still there are a couple of things to look at. For instance, are transactions enabled in your database? (and, if so, could you live without them?) You may have hit a limit on the number of rows to keep locked until the next 'commit work'. -- Harry Bochner -- bochner@das.harvard.edu