How To Fix HH059 - Change the 'lock mode' of the specified table in 'row'

HH059 - Overview

• Message type: E = Error

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

• Message number: 059

• Message text: Change the 'lock mode' of the specified table in 'row'

What causes this issue?

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'.

System Response

How to fix this error?

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH059 - Change the 'lock mode' of the specified table in 'row' ?

  The SAP error message HH059, which states "Change the 'lock mode' of the specified table in 'row'," typically occurs in the context of database operations where there is a conflict in the locking mechanism for a specific table. This error is often related to issues with table locking in the SAP system, particularly when multiple processes are trying to access or modify the same data concurrently.
  
  Cause:
  
  Lock Conflicts: The error usually arises when there is a conflict in the lock modes being used for a table. For example, if one transaction is trying to acquire an exclusive lock while another transaction holds a shared lock, this can lead to a deadlock or a lock conflict.
  Database Configuration: The configuration of the database or the specific table's locking settings may not be optimal for the operations being performed.
  Long-Running Transactions: If a transaction takes too long to complete, it can hold locks for an