Glossary

3. Avoid Common Bottlenecks

**Enqueue contention**: Keep exclusive locks on shared resources for the minimum time - **File I/O contention**: Use VSAM LSR (Local Shared Resources) buffer pools - **DB2 thread waits**: Monitor thread pool utilization and increase limits if needed - **TSQ contention**: Use unique TSQ names per ter

Learn More

Related Terms