Chapter 8. DB2 Programming Features and Strategies
Database applications provide programmers with the challenge of utilizing DBMS resources efficiently. DB2 provides rich features such as UDFs, stored procedures, concurrency, and transaction management. Using these features properly make the difference between well-tuned applications and headaches such as deadlocks and poor performance.
For example, a remote application that makes dozens of needless queries will suffer a bottleneck in terms of network traffic and DBMS processing time. In contrast, an application that effectively uses DB2 to perform business-logic and function-related tasks saves tremendous client-side overhead, and will see significant performance benefits. One of the keys to ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition 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.
