Re: HELP: Informix Online on HP-K460 is NOT-SCALABLE?
>Online on HP-K460 is NOT-SCALABLE?
>From: "James Francis" <jfrancis@dxi.com>
>Date: Sat, Oct 4, 1997 13:48
>The relevant parameters from the onconfig file:
>MULTIPROCESSOR 1
>NUMCPUVPS 3
>NETTYPE ipcshm,2,300,CPU
>NETTYPE soctcp,1,100 ,NET
>BUFFERS 7200>PDQPRIORITY 0
>OPTCOMPIND 0
First of all, your buffers are really way too small for this type of machine,
unless this is a data-warehouse system and you are planning on doing
everything via PDQ.
What is the case number? I'd like to see onstat -p, onstat -g seg, the output
of several "select * from sysmaster:syssqexplain order by sqx_estcost desc",
and the onconfig in the case notes. Can you ensure that this information is
in the case?
Madison Pruet