Set a TIMEOUT Value for a Lock Wait
To limit to thirty seconds the time that a lock request remains pending, issue the following statement:
set lockmode session where timeout = 30;
To immediately return control to the application when a lock request is made that cannot be granted, use TIMEOUT=NOWAIT. For example:
set lockmode session where timeout = nowait;