 |
» |
|
|
|
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
|
|
