 |
» |
|
|
|
|
|
5.7 How do I use transaction timeout limits?
Key points
- The timeout limit for a transaction is controlled by the
SET USER TIMEOUT
statement, and the MaximumTimeout and DefaultTimeout parameters in
the DBECON file. The SET USER TIMEOUT statement specifies the amount of time
a transaction will wait if a required database resource (such as a transaction
slot, or a lock) is not available. You can set the timeout limit to
MAXIMUM (in which case the MaximumTimeout value is used), DEFAULT (the
DefaultTimeout is used), or to an explicit number of seconds or minutes.
If an explicit number is specified, the value must be less than or equal to
MaximumTimeout, or the statement will fail.
- If you do not issue a
SET USER TIMEOUT statement before you start a
transaction, the timeout limit for the transaction is automatically set to the
DefaultTimeout value.
- The default value for MaximumTimeout is NONE, which means that a
transaction will never timeout (that is, it will wait as long as is necessary
to obtain a database resource). The default value for DefaultTimeout is
MAXIMUM, which means that the MaximumTimeout is used as the default.
These DBECON parameters can be modified in the
START DBE statement, or by
using the SQLUTIL ALTDBE command.
Page last updated on November 29, 1995
|
|
|
Printable version
