How To Fix HH033 - Editez le fichier Informix ONCONFIG

HH033 - Overview

• Message type: E = Error

• Message class: HH - (Long) text for check tool 'infcfgcheck'

• Message number: 033

• Message text: Editez le fichier Informix ONCONFIG

Quelle est la cause de ce problème?

You configured the ONCONFIG parameter 'LOCKS' to be very large.
Background: Each 'lock' reserves 43 bytes (OSF/1: 72 bytes) in the
resident shared memory area, so you should make sure that you do not
configure more 'locks' than necessary.
Using the UNIX command 'onstat -k | grep total', you can check the
number of 'locks' currently reserved: 'active' designates this value,
'total' is the configured maximum.
However, you should bear in mind that there are 'special' DB actions
(for example, CLIENT COPY) or customer developments that temporarily
require considerably more locks!!!
In the case of customer developments, you should make sure - if
the logic allows this - that commits are performed more frequently
or tables locked completely, if necessary (-> fewer locks).
If the preconfigured maximum threshold value is clearly too low, you
can use transaction DB17 to increase the threshold value or deactivate
the individual check.
Refer to Note '18993'in any case. It contains the latest information
regarding 'LOCKS'.

Réponse du système

Comment corriger cette erreur?

To reconfigure the parameter, edit the file
'$INFORMIXDIR/etc/$ONCONFIG' (as user'informix'). However, you should
not configure 'LOCKS' smaller than '500,000', if possible.
CAUTION: The change only takes effect when the database is restarted.

Extrait du message d'erreur du système SAP. Copyright SAP SE.