Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Troubleshooting Guide

Are There Enough Locks?

Some extra symptoms that identify this condition are:

Solution 1: Split Long Transactions

A transaction running on a node is not allowed to use more than 25% of the number of locks allocated on that node. Read transactions running at the “repeatable read” isolation level and the update/insert/delete transactions hold the locks until the transaction terminates. Therefore, it is recommended to split long transactions into small batch of separate transactions.

Solution 2: Increase the number of locks

Use hadbm set NumberOfLocks= to increase the number of locks.