Re: Error Num -229

> > Why can I not create this temp file? > > DBTEMP is set to HOMEDIR$/tmp > > Changed DBTEMP to INFORMIXDIR$/tmp and > > no success. > > .....and YES I have permissions. > > Online will sometimes incorrectly fail queries with 229 errors if it estimates a huge number of rows returned (like 2,147,483,647 -- see sqexplain.out) and freaks out and immediately grabs every block in the first chunk in every temp dbspace for the result set. The query fails sometime later when it tries to write something else (like a hash table) to temp and there is no space available. You can avoid this by allocating temp dbspaces with multiple chunks. Doug