HP 3000 Manuals HP 3000 Manuals
SET USERTIMEOUT
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