DB2® Universal Database for OS/390® Version 7.1 Certification Guide

System Parameters

There are some system parameters (DSNZPARMs) that are used to control some aspects of locking.

RECURHL	The use of the RECURHL = YES DSNZPARM can help with concurrency because it will allow DB2 to release the locks that are held by a cursor defined WITH HOLD.
IRLMRWT	This is the number of seconds that a transaction will wait for a lock before a timeout is detected. The IRLM uses this for timeout and deadlock detection. Most shops take the default of 60 seconds, but in some high-performance situations where they wanted the detection to occur sooner (so the applications were not incurring excessive lock wait times), it has been set lower. If this was hit often, the applications were reviewed and tuned.
XLKUPDLT	This DSNZPARM allows ...