-40: Lock collision


When the option (NOWAIT) is specified in the LOCK statement or in the LOCK option , this error message signals that the lock request conflicts with the locks of other users.

User Action:

In interactive mode, another job can be activated which does not require the desired lock.

As an alternative, you can wait for the lock to be released by specifying the same SQL statement without the '(NOWAIT)' option.