temporary dbspace question

HI, I defined 8 temporary dbspace ,everyone is 5GB. DBSPACETEMP TMPDBS01,TMPDBS02,TMPDB03,TMPDBS04,TMPDBS05,TMPDBS06,TMPDB07,TMPDB08 sometimes ids report tmpdbs01 is full, "create temp talbe " will only write to tmpdbs01 dbspace. but sometimes ids report TMPDB03 is full or TMPDBS06 is full. it nevefr report tmpdbs02 is full. Why ? do anybody know how ids use the temporary dbspace internally ? thanks for your time.

Just to get the obvious out of the way: Have you verified that these 'temp' dbspaces were created with the '-t' flag? Does the 'T' show in the third flag column for the dbspace line in the onstat -d report? Art Art S. Kagel, Principal Consultant ASK Database Management 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 Fri, Jan 17, 2014 at 9:32 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > HI, > > I defined 8 temporary dbspace ,everyone is 5GB. > > DBSPACETEMP > TMPDBS01,TMPDBS02,TMPDB03,TMPDBS04,TMPDBS05,TMPDBS06,TMPDB07,TMPDB08> > sometimes ids report tmpdbs01 is full, "create temp talbe " will only > write to > tmpdbs01 dbspace. > but sometimes ids report TMPDB03 is full or TMPDBS06 is full. > > it nevefr report tmpdbs02 is full. > Why ? do anybody know how ids use the temporary dbspace internally ? > thanks for your time. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11349868d82c5004f02bb9a3

Yes, I created it using -t flag in the onspaces command.