Deploying change commands fails due to the maximum number of lock requests

IBM® Data Studio returns an error when deploying a change command.
Symptoms
IBM Data Studio returns the error code SQL0912N while deploying your change commands.
Causes
The maximum number of lock requests has been reached.
Resolving the problem
Resolve the problem by:
  • Committing more often
  • Increasing your lock size
Important: Stop and restart DB2® before deploying your change commands. If you do not restart DB2, you might still receive the SQL0912N error.

Feedback