How To Fix HH059 - Bitte ändern Sie den 'lock mode' der spezifizierten Tabelle in 'row'

HH059 - Overview

• Message type: E = Error

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

• Message number: 059

• Message text: Bitte ändern Sie den 'lock mode' der spezifizierten Tabelle in 'row'

Was verursacht dieses Problem?

The specified table (belonging to 'sapr3') has no 'row-level-locking'.
This is detrimental to the performance and can provoke update
terminations for this table. An Informix bug was also found
for 'page-level-locking'. All the tables belonging to 'sapr3' should
be used in locking mode 'row'.

Systemantwort

Wie behebe ich diesen Fehler?

Change the locking mode of the specified table, for example with the
following SQL statement (with 'dbaccess'):
'alter table <tabname> lock mode (row);'.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE