Efficent Software Development with DB2 for OS/390: Organizational and Technical Measures for Performance Optimization: 1999

This text points out how to ensure professional and efficient database software development in DB2 mainframe and client/server environments. This book covers both technical aspects (performance, tuning) and organizational measures (economical performance) and consequently, 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 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 such performance problems, this book also describes and explains well-proven measures to avoid such problems. It 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.

Table of Contents

Performance problems: symptoms, causes, and measures – organizational measures in software development – case studies – tuning – checklists – new stuff for application development In order to get the best out of DB2 in terms of features that are relevant for application development, certain selected new topics in DDL and DML that came with Version 5 are covered by this edition. Performanceprobleme: Symptome, Ursachen und Massnahmen – Organisatorische Massnahmen in der Softwareentwicklung – Fallstudien – Tuning – Checklisten “Zusatzlich wird in diesem Buch auf die Erweiterungen der Version 5 eingegangen.”

Author Biography

The author Jurgen Glag is based in Dusseldorf Germany, where he holds a leading position with a major software company. He has gained over 15 years of experience in the field of application development. His main areas of expertise are project management, product development and DB2 consulting. He is frequent speaker at GUIDE, IDUG and other events where he has held presentations about DB2 performance and tuning. Dipl.Math. Jurgen Glag ist als Projektmanager bei einem grossen Beratungsunternehmen in Dusseldorf beschaftigt. Seit uber 15 Jahren arbeitet er im Bereich der Anwendungsentwicklung. Seine Arbeitsschwerpunkte liegen im Management von Projekten fur die Versicherungswirtschaft sowie in der DB2-Beratung. Uber Performance und Tuningmassnahmen hinsichtlich des Einsatzes von DB2 hat er auf Seminaren mehrfach Vortrage gehalten.