TXTIMEOUT configuration parameter
Use the TXTIMEOUT configuration parameter to specify the amount of time that a participant in a two-phase commit waits before it initiates participant recovery. This parameter is used only for distributed queries that involve a remote database server. Nondistributed queries do not use this parameter.
- onconfig.std value
- TXTIMEOUT 300
- values
- Positive integers
- units
- Seconds
- takes effect
- After you edit your onconfig file and restart the database server.
- When you reset the value dynamically in your onconfig file by running the onmode -wf command.
- When you reset the value in memory by running the onmode -wm command.