Connection Management Improvements
Online transaction processing (OLTP) database systems introduce significant challenges in managing client database connections. Common problems include high volumes of connections with very few transactions and connected applications with significant idle time between transactions. The latter problem is especially common in Internet applications where database transactions are prompted directly by person-driven applications, (e.g., an e-business site selling airline tickets).
In many database servers today, each application connection requires a dedicated database agent. In DB2, a database agent (a process in UNIX and a thread in Windows) performs much of the SQL processing for connected applications. There ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
