Re: How To: multi threads, Fragmentation in Online 7.1.
Let me know your results I have the exact same enviornment and will be
fragging some talbes in the next few weeks. Also, How many CPUS? I have 4
-------------------------------------------------------------------------
Cheryl Kendricks
Internet: cherylk@spamis.jcdc.doleta.gov
OR
cherylk@prod1.jcdc.doleta.gov
OR
kendric@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Wed, 10 Apr 1996, 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.
>