Parameter
dbs/db4/timeout_retry
Short text
Number of attempts to access locked tables/rows
Parameter Description
Total number of attempts to repeat the execution of an SQL statement when a table or record is locked (SQL0913). Note that this sets the overall time a database request waits for a table (row) to become available to a maximum of ([n]+1) * WAITFILE seconds (([n]+1) * WAITRCD seconds), where WAITFILE and WAITRCD are table attributes, which are visible using the DSPFD command.
If dbs/db4/alter_table_timeout_retry is set to -1, it will take the value of dbs/db4/timeout_retry.
Application Area
Database
Default Value
3
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
dbs/db4/alter_table_timeout_retry
Values allowed
Integer value
