SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-46
Locking
Locking
These attributes determine how NonStop SQL/MX locks objects:
If you issue a CONTROL TABLE statement for the TABLELOCK or TIMEOUT option,
the specified control table value overrides the system-defined default setting. See
CONTROL TABLE Statement
on page 2-46.
Attribute Setting
MAX_ROWS_LOCKED_
FOR_STABLE_ACCESS
The maximum number of rows locked by DP2 in STABLE
ACCESS mode before the buffer is returned to the file system.
The number of rows which are actually locked depends on this
number and the size of the buffer. To increase concurrency, you
can decrease this value so that more messages are used to
return the same amount of data.
The default value is 1.
TABLELOCK Set to SYSTEM, ON, or OFF to indicate whether the system
determines when table locks are to be used for accessing the
table or view (SYSTEM), table locks are always used (ON), or
table locks are not used (OFF).
The default is SYSTEM.
For more information on table locks, see Database Integrity and
Locking on page 1-10.
TIMEOUT The time in hundredths of seconds to wait for a lock before
returning an error. The range of values you can enter is from -1 to
2147483519. The value -1 directs NonStop SQL/MX not to time
out. The value 0 directs NonStop SQL/MX not to wait for a table
lock. If the lock cannot be acquired, an error is returned
immediately.
The default is 6000 in hundredths of seconds, which is equivalent
to 60 seconds.
This default is valid for compile-time timeout. For run-time
timeout, see the SET TABLE TIMEOUT Statement
on
page 2-214.