Checking Key Tuning Parameters (Informix)
Checking Key Tuning Parameters (Informix)
Use
This procedure tells you about checking key tuning parameters from the Informix
ONCONFIG file that influence the performance of the Informix database.For up-to-date recommendations on Informix parameters, see SAP Note 41360.
Prerequisites
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 database manufacturer, Informix. Use recommendations from the Informix documentation where they differ from any recommendations given here.
Procedure
You check the key tuning parameters in your Informix database (listed in alphabetical order):
In
MULTIPROCESSOR, NUMCPUVPS & SINGLE_CPU_VP (Informix) you can find a discussion of the interaction of several parameters.