Important Tuning Parameters (Informix) 

The information given in this section contains suggestions based on SAP’s experience with Informix customers. The definitive documentation for Informix performance tuning comes from the DBMS manufacturer, Informix. Use recommendations from the Informix documentation where they differ from any recommendations given here.

 

See also:

ALARMPROGRAM (Informix)

BUFFERS (Informix)

CHUNKS (Informix)

CKPTINTVL (Informix)

CLEANERS (Informix)

DD_HASHSIZE (Informix)

LBU_PRESERVE (Informix)

LOGBUFF (Informix)

LRU_MAX_DIRTY, LRU_MIN_DIRTY (Informix)

LRUS (Informix)

LTAPEDEV (Informix)

MULTIPROCESSOR (Informix)

NETTYPE (Informix)

NOAGE (Informix)

NUMAIOVPS (Informix)

NUMCPUVPS (Informix)

PHYSBUFF (Informix)

PHYSDBS (Informix)

PHYSFILE (Informix)

SHMADD (Informix)

SHMTOTAL (Informix)

SHMVIRTSIZE (Informix)

SINGLE_CPU_VP (Informix)

TRACE, TRACEFLAGS (Informix)

USEOSTIME (Informix)

 

The following contains a discussion of the interaction of three parameters:

MULTIPROCESSOR, NUMCPUVPS & SINGLE_CPU_VP (Informix)