Reducing lock contention

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: