Efficient Software Development with DB2 for OS/390

Efficient Software Development with DB2 for OS/390

4.11 - 1251 ratings - Source

JA¼rgen Glag's book points out how to ensure professional and efficient database software development in DB2 mainframe and client/server environments. The asset of this book is that technical aspects (performance, tuning) and organizational measures (economical performance) are covered. Consequently, this book is suitable particularly for organizations that want to use DB2 in an economical and safe way. Work in various large production systems with DB2 revealed that most performance problems arise either from a certain critical transaction load onwards or for particularly large tables. Many measures can be taken in order to identify and to solve these problems during software development and not, as is often the case, only in production environment. Beyond explaining the causes for performance problems, this book also describes and explains well-proven measures to avoid such problems. The book particularly addresses those persons who are responsible for data processing and quality assurance; project leaders and project managers in the data processing area; and software and application developers. Das Buch von Glag zeigt, wie professionelle und effiziente DB-Anwendungsentwicklung im DB2-GroAŸrechnerbereich und Client/Server-Umfeld sichergestellt werden kApnnen. Der Vorzug des Buches ist es, daAŸ sowohl die technischen Aspekte (Performance, Tuning) als auch organisatorische MaAŸnahmen zur Optimierung (wirtschaftliche Performance) dargestellt werden. Damit eignet sich das Buch insbesondere fA¼r den Einsatz in Unternehmen, die DB2 kostengA¼nstig und sicher einsetzen wollen. Bei der Arbeit in mehreren groAŸen produktiven DB2-Umgebungen hat sich gezeigt, daAŸ die meisten Performance-Probleme entweder erst ab einer bestimmten kritischen Transaktionslast oder bei besonders umfangreichen TabellengrApAŸen auftreten. Um diese Probleme nicht erst in der Produktionsumgebung, sondern bereits wAchrend der Softwareentwicklung erkennen und lApsen zu kApnnen, sind eine Reihe von MaAŸnahmen2.3 aquot;Delivery Times Instead of Response Timesaquot; in On-line Operation For this category of problems, too, there are many causes that can be divided into several classes. The most important causes are: a€c too many IOs, q physical sorting of large result sets, q complex queries, a€c large ... with referential integrity 2.3.2 Reducing 16 Performance Problems: Symptoms, Causes, Measures 2.3 aquot; Delivery Timesanbsp;...

Title:Efficient Software Development with DB2 for OS/390
Author:Jürgen Glag
Publisher:Springer Science & Business Media - 1999-10-28


You Must CONTINUE and create a free account to access unlimited downloads & streaming