dbs/db4/alter_table_timeout_retry

Parameter

dbs/db4/alter_table_timeout_retry

Short text

Number of retry attempts ALTER TABLE

Parameter Description

Number of attempts to execute an ALTER TABLE statement again, if a lock situation occurred during its execution (SQL0913).

Note that this means that the total wait time in the case of failure is (+1) * WAITFILE seconds, where WAITFILE is the table attribute of the same name, which can be viewed with the command DSPFD.

If you set the value -1, the value of dbs/db4/timeout_retry is used.

For more information, see SAP Note 1241447.

Application Area

Database

Default Value

-1

Who is permitted to make changes?

DB administrator

Database System Restrictions

This parameter is only evaluated for DB2 for IBM i.

Are other parameters affected or dependent?

No.

Values allowed

Integer value