What it means
The lock manager noticed a database lock held for an unusually long time and dumped details of it. HCL describes it as informational, but frequent dumps point to contention or slow storage.
Common causes
- A long view index update or
updallon a large database - Two tasks working on the same database, for example compact and fixup
- Slow or overloaded disk I/O
- A deadlock defect in some releases
Quick fixes
- Note the database named in the dump and check what is running against it with
show tasks - Let long tasks finish, or reschedule compact, fixup and updall so they do not overlap
- Check disk latency on the data and transaction log volumes
- If it persists or the server hangs, run
nsd -detachthree times a few minutes apart and log a case with HCL