 |
» |
|
|
|
Specifies how long SQLMON waits for a database resource that is unavailable Scope |  |
SQLMON Only SQLMON Syntax |  |
SET U [SERTIMEOUT] [ Seconds OFF ] Parameters |  |
- Seconds
The number of seconds SQLMON waits. Seconds is an integer value greater than or equal to 0. The value 0 is equivalent to OFF.
The default value is 5. - OFF
Specifies that SQLMON does not wait.
Description |  |
The resources SQLMON might wait for include transaction slots and locks, as explained below: - Transaction Slots
If you issue SET DBENVIRONMENT and DBECONNECT is ON, SQLMON connects to the DBEnvironment and creates a transaction. If the transaction limit is reached,
SQLMON waits for a transaction slot for Seconds
seconds. - Locks
If SQLMON tries to lock an object that is already locked in a conflicting mode, SQLMON waits until the lock is granted or until Seconds seconds pass.
If SQLMON cannot obtain the resource in the allotted time, it displays an error message.
Examples |  |
To have SQLMON wait 10 seconds for a database resource, enter
SQLMONITOR OVERVIEW => SET USERTIMEOUT 10
|
If you omit the last parameter, SQLMON prompts for it, as in
SQLMONITOR OVERVIEW => SET USERTIMEOUT
NUMBER OF SECONDS: 10
|
|