System Parameters
Table 16-5 lists some system parameters (DSNZPARMs) that are used to control aspects of locking.
| Parameter | Description |
|---|---|
| RECURHL | The use of the RECURHL = YES DSNZPARM can help with concurrency because it allows 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 detection must occur sooner (so the applications are not incurring excessive lock wait times), it is been set lower. If timeouts or deadlocks are hit often, the applications ... |
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
