Lock contention can impact Adaptive Server’s throughput and response time. You need to consider locking during database design, and monitor locking during application design.
Solutions include changing the locking scheme for tables with high contention, or redesigning the application or tables that have the highest lock contention. For example:
Add indexes to reduce contention, especially for deletes and updates.
Keep transactions short to reduce the time that locks are held.
Check for “hot spots,” especially for inserts on allpages-locked heap tables.
