Re: Error 244 Fetch Error

Michael Todd (mtodd@shore.net) wrote: : Error 244 (Could not do a physical order read to fetch next row) has been : occurring more frequently in our application. It comes up during a fetch : next row call. When we get the error, that particular query is incomplete; : however subsequent queries work fine. We are even able to repeat the same : query and it work fine on the second try. <snip> : Thanks in advance. : Marv Todd, Wang Labs. : mtodd@shore.net : -- : Michael Todd : mtodd@shore.net Actually, we had that problem appear before we discovered the DBTEMP environment variable. Our /tmp partition is fairly small, and, as the default location that Informix 5.04 uses for temporary sort files, it filled up rapidly when we did certain selects on >750,000 records. Creating appropriate indexes and setting DBTEMP made the problem go away for us. Hope this helps! -- Jonathan Crawford Ark Technologies, Inc.