Lock Timeout Value
Use this system parameter to set the amount of time (in seconds) that the CDC Replication Engine for Db2® for i waits before attempting to modify a locked user or metadata table.
Versions supported—CDC Replication Engine for Db2 for i version 6.1 and later
When CDC Replication attempts to modify a locked table, it places a notification in the Event Log. These notifications identify the specific table and row that CDC Replication could not modify.
If a table or row is locked, CDC Replication waits for a specified timeout period to expire before attempting to apply data again.
- Applies to
- Source and target datastores
- Minimum Setting
- 2 seconds
- Maximum Setting
- 60 seconds
- Default Setting
- 30 seconds