Error -567

Hallo Everyone, Every now and then we get the following error message in some of our reports - Error status -567. Cannot write sorted rows All I can think of is that our temporary sort space got full at the time the report was run. Is this true and what are my options for fixing this ? I have the following variable set in my onconfig file so that the engine will be used for sorting and not Unix (/tmp) - DBSPACETEMP tempdbs_w,tempdbs_x,tempdbs_y,tempdbs_z Each of these tempspaces have the same size. I'll appreciate any help you can give me on this. Regards Dirk

In my experience with Informix-SE the DBTEMP environment variable must be set to override the default usage of /tmp eg. export DBTEMP=/var/tmp Make sure its set before invoking dbaccess or sqlexecd. -- Darren Kelly Steadycom Pty Ltd Senior Support Engineer http://www.steadycom.com.au mailto:dpkelly@steadycom.com.au DirkM wrote in message <01be4847$9e1e0d00$f80910ac@8829BYP20426>... >Hallo Everyone, > >Every now and then we get the following error message in some of our >reports - > > Error status -567. Cannot write sorted rows > > >All I can think of is that our temporary sort space got full at the time >the report was run. Is this true and what are my options for fixing this ? >I have the following variable set in my onconfig file so that the engine >will be used for sorting and not Unix (/tmp) - > DBSPACETEMP tempdbs_w,tempdbs_x,tempdbs_y,tempdbs_z > > Each of these tempspaces have the same size. >I'll appreciate any help you can give me on this. > >Regards >Dirk