229: Could not open or create a temporary file.

Hi, I am trying to perform the follow select first 5 * from traffic_by_hours; and getting the below result. 229: Could not open or create a temporary file. Error in line 1Near character position 37 how can I fix it? Yoni

Hi, probably filesystem /tmp or filesystem in DBTEMP is full or dbspace for temporary files is full try df or onstat -d Petr Dne 2.3.2017 v 11:33 YONATAN ROSENFELD napsal(a): > Hi, > I am trying to perform the follow > select first 5 * from traffic_by_hours;> > and getting the below result. > 229: Could not open or create a temporary file. > Error in line 1> Near character position 37 > > how can I fix it? > > Yoni > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Create a temp dbspace or expand the ones you have. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Mar 2, 2017 at 5:33 AM, YONATAN ROSENFELD <yoni.rosenfeld@gmail.com> wrote: > Hi, > I am trying to perform the follow > select first 5 * from traffic_by_hours;> > and getting the below result. > 229: Could not open or create a temporary file. > Error in line 1> Near character position 37 > > how can I fix it? > > Yoni > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1146fd1ca3f9600549bdb1ab