Re: Multiple Temp dbspaces

"Jay" <remove:jay@td.ca> wrote in message news:H8iRa.4194$eP6.610072@news20.bellglobal.com... > Hi, > > I'm running 7.24, and have listed 3 temporary dbspaces in DBSPACETEMP, but > when I load a temporary table only the first dbspace is being used. I have > set PDQPRIORITY to 100, and all temp dbspaces reside on separate disks. The> only way I can make Informix use all 3 dbspaces is if I use the "FRAGMENT BY > ROUND ROBIN IN tempdbs1. tempdbs2, tempdbs3" clause of the "CREATE TEMP > TABLE" statement. > > I was under the impression that all I have to do for parallelism against > temp dbspaces was list them in the onconfig file, am I wrong and set > PDQPRIORITY >0, am I wrong? You are wrong. Only implicit created temp tables are fragmented automatically and that too with no log clause. select .. from .. into temp tmp_table with no log ; the above will be fragmented. for explicitly created temp tables create temp table tmp_table (... ) with no log ; you must mention FRAGMENT BY ROUND ROBIN clause. The easiest way, if possible of doing it is to create a blank implicit table. for e.g. select ... from .. where 0=1 into temp tmp_table with no log ; this will create the temp table with round robin fragmentation but will put no rows where because the WHERE clause is 0=1. Now you can add rows to this table.

rkusenet wrote: > "Jay" <remove:jay@td.ca> wrote in message news:H8iRa.4194$eP6.610072@news20.bellglobal.com... > >>Hi, >> >>I'm running 7.24, and have listed 3 temporary dbspaces in DBSPACETEMP, but snip.... Jay - I'd upgrade to at least 7.31.x before spending toooo much time chasing this - If 7.24 is still supported, it won't be for long. 7.31.x will be supported indefinitely. Greg