Re: How To: multi threads, Fragmentation in Online 7.1.

Hello, PSORT_NPROCS is only used for building indexes. In either your $ONCONFIG file, or your environment or before you sql statement do you set PDQPRIORITY? For a query to be parallelized PDQPRIORTY must be set to something greater then 0. The higher the PDQPRIORTY the more resources allocated for that query. Also depending on your query it may eliminate fragments and not need to use multiple threads. Jacques Rajesh N. Malhotra wrote: > > Informix Gurus, > > I have fragmented a few tables in our schema, and have updated > statistics on those tables. I set the PSORT_NPROCS variable in the > onconfig to the largest level of fragmentation (10). > > Now when I run queries on the fragmented tables, and monitor them using > > onstat -g ses <ses#>> > the #RSAM THREADS is always 1. Inspite of fragmentation, I cannot use > the multi threaded architecture of the Online engine. > > We are running Online 7.11.UC1 on an IBM RS6000 running AIX 4.1.4. Any > help on this matter appreciated. > > Thanx, > > Raj. -- ********************************************************************* * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Tech Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * *********************************************************************