Re: Way temp dbspaces are filled

Get rid of the spaces in your onconfig list. You have DBSPACETEMP tempdbs1, tempdbs2, tempdbs3, tempdbs4, tempdbs5 change it to DBSPACETEMP tempdbs1,tempdbs2,tempdbs3,tempdbs4,tempdbs5 Let me know if this works. You will have to bounce. I had the same problem in an earlier version of 7.2X with the space after tempdbs1 it ignored the other tempdbs's. Lem Beason <ltbeason@my-deja.com> on 11/23/99 02:04:58 PM Please respond to Lem Beason <ltbeason@my-deja.com> To: informix-list@iiug.org cc: (bcc: Kernoal Stephens/STS/AUTOZONE) Subject: Re: Way temp dbspaces are filled In article <rTz_3.1055$qy2.6178@newsfeed.slurp.net>, rwilson@ntsource.com (Rob Wilson) wrote: > mars1972@my-deja.com wrote: > : In article <81edv8$26h$1@nnrp1.deja.com>, > : Lem Beason <ltbeason@my-deja.com> wrote: > : > Good day to all. I have a question about how Informix > : > fills and uses the temp dbspaces. > : > > : > Machine: Sun Ultra Enterprise 10000 > : > OS: SunOS 5.6 > : > Informix: 7.30.UC9 > : > > : > I think that this version of Informix uses the temp spaces in a > : > round robin fashion both when you create a temp table with no log > : > and when the engine needs to use the temp spaces during the sort > : > portion of a query. Based on this statement, will the engine use > : > the remaining temp spaces if one fills up? > : > > : > I recently had a situation where I was getting the error 229. > : > This was caused by the root dbs being full, but in the > : > investigation I noticed that 1 temp dbspace was completely full, > : > the remaining 4 were empty. I started wondering if this would > : > cause problems in trying to use the temp spaces. > : > > : > DBSpace Size Used > : > tempdbs1 512000 512000 > : > tempdbs2 512000 53 > : > tempdbs3 512000 53 > : > tempdbs4 512000 53 > : > tempdbs5 512000 53 > : > > > My guess from this would be that you haven't defined TEMPDBS with all > these spaces or the temp spaces weren't all added with -t flag. From the onconfig file. DBSPACETEMP tempdbs1, tempdbs2, tempdbs3, tempdbs4, tempdbs5 None of the user profiles set a DBSPACETEMP variable or a TEMPDBS variable. Looking at onstat -d, all of the temp spaces have the T status flag. The only thing I can think of is that someone had purposly created something in that particular temp space. > Informix will round robin the spaces, when one fills up it stops and > reports there is no temp space. It gets a list of temp spaces from > TEMPDBS, however. That is what I thought, but after arguing with the in-house DBA for a little while, I thought it best to check my facts. TEMPDBS is used on NT, isn't it? > > -- > Rob Wilson > rwilson@ntsource.com Thanks for your reply. Lem Beason MIC, Inc. lbeason@micinc.com Sent via Deja.com http://www.deja.com/ Before you buy.