NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-49
Considerations—COMMIT Option
{ value [ SECOND[S] ] }
TIMEOUT { DEFAULT [ SECOND[S] ] }
{ NEVER }
sets the time allowed for lock requests to complete during the commit phase, as
follows:
The default is TIMEOUT DEFAULT.
If the file system cannot grant a lock request from the operation within the specified
time, an error occurs and the operation performs the action specified in the
ONCOMMITERROR option.
ONCOMMITERROR commit-option
specifies a COMMIT option to take effect if a retryable error occurs during the
commit phase.
Retryable errors include file in use, lock request timeouts, resource unavailability,
and BEFORE/AFTER time window misses (error numbers 12, 40, 73, 1057, 1615,
1616, 1617, 1618, 1621, 1622, and 3001 to 3999).
A nonretryable error always causes SQL to cancel changes to the database and
terminate the operation, no matter what you specify in the ONCOMMITERROR
option.
ONCOMMITERROR is recursive because it appears within a COMMIT option and
specifies another COMMIT option. You can specify up to three COMMIT options
on a single statement; specifying four or more causes an error.
The default is ONCOMMITERROR ROLLBACK WORK.
ROLLBACK [WORK]
cancels changes made to the database during the operation and terminates the
operation.
Considerations—COMMIT Option
•
Each COMMIT option replaces the previous one
value Wait the specified number of seconds (a number in the range 0.01 to
21474836.47); wait indefinitely if value is -1.
DEFAULT Wait 60 seconds.
NEVER Wait indefinitely. Your operation acquires the lock after all concurrent
locking transactions complete.