Set lock mode

Issuing a SET LOCK MODE TO WAIT or SET LOCK MODE TO WAIT n statement on a secondary server sets the lock wait timeout value for that session just like on a primary server. The value set by SET LOCK MODE is used by the proxy thread created for the current session on the primary server when it performs updates from a secondary server. If the value for SET LOCK MODE is greater than the ONCONFIG parameter value of DEADLOCK_TIMEOUT, the value of DEADLOCK_TIMEOUT is used instead.


Copyright© 2019 HCL Technologies Limited