The sysparm option is IRLMRWT, default 30s.

On Db2 v13, it can be changed by code.

El dom, 4 ene 2026, 10:22, Binyamin Dissen <
[email protected]> escribió:

> I am going thru the DB2 options and cannot find an obvious parm that
> controls
> the amount of time before DB2 fails an SQL due to deadlock.
>
> It appears that 10 minutes is the default.
>
> --
> Binyamin Dissen <[email protected]>
> http://www.dissensoftware.com
>
> Director, Dissen Software, Bar & Grill - Israel
>
> ----------------------------------------------------------------------
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to [email protected] with the message: INFO IBM-MAIN
>

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to