DATA DEF TIMEOUT field (DDLTOX subsystem parameter)

The DDLTOX subsystem parameter specifies how long a request for SQL data definition is to wait for a resource before timing out. This parameter is used for the processing of DDL statements and GRANT, REVOKE, and LOCK statements.

Acceptable values: Start of change0–254End of change
Default: 1
Update: option 20 on panel DSNTIPB
DSNZPxxx: DSN6SPRM DDLTOX
0
Db2 resolves the timeout or deadlock situation by returning an error for data definition, GRANT, REVOKE, and LOCK statements.
1–254
The actual timeout value is the product of the value of this subsystem parameter and the value of the IRLMRWT subsystem parameter. The default value of 1 means that the value of the IRLMRWT subsystem parameter is used as the timeout value.