Glag Efficient Software Development with DB2 for OS/390

Organizational and Technical Measures for Performance Optimization
1998
ISBN: 978-3-322-93863-3
Verlag: Vieweg & Teubner
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Deutsch, 150 Seiten, eBook

Reihe: Efficient Software Development

Zielgruppe

Research

Autoren/Hrsg.

Glag, Jürgen

Weitere Mitwirkende

Fedtke, Stephen

Translated by Kollar-Fiedrich, Ursula

Inhaltsverzeichnis

1 Introduction.- 1.1 Why this Book?.- 1.2 Target Groups.- 2 Performance Problems: Symptoms, Causes, Measures.- 2.1 Locking Problems.- 2.2 Queuing Problems.- 2.3 “Delivery Times Instead of Response Times” in On-line Operation.- 2.4 Excessively Long Runtimes in Batch.- 2.5 Summary.- 3 Organizational Measures in Software Development.- 3.1 Application Scenario and Access Profile.- 3.2 Design of Critical Batch Runs.- 3.3 Access Modules.- 3.4 Reducing Data Accesses.- 3.5 Considerations Regarding the Application Architecture.- 3.6 Standards for Software Development.- 3.7 Using Quality Assurance Tools.- 4 Case Studies.- 4.1 Queues in On-line Operation.- 4.2 Avoiding Hot-Spots.- 4.3 Joins with Non-uniform Distribution of Attribute Values.- 4.4 Formulation of Restart Keys in Cursors.- 4.5 Reducing Synchronous lOs for Hierarchical Structures.- 4.6 Comparison of LOAD and INSERT Procedures.- 5 Tuning.- 5.1 Unavoidable Tuning Measures.- 5.2 Economical Procedure with ABC Analysis.- 5.3 Sequence of the Activities.- 5.4 Expenditure for Tuning.- 5.5 Effort Minimization for Future Tuning Measures.- 5.6 Adjustment of the Procedure Model.- 5.7 Staff Training.- 5.8 Measuring the Tuning Results/Success.- 6 Checklists.- 6.1 Checklist for the Application Development.- 6.2 Tasks of a DBA Group.- 6.3 Application Scenario.- 6.4 Access Profile.- 6.5 Checklist for System Design.- 6.6 Evaluating the DB2 Catalog for Critical Objects.- 6.7 Inverting a Timestamp.- 7 Some Additional Stuff for Application Development.- 7.1 DML Extensions.- 7.2 DDL Extensions.

Über Autor(innen)

The author Jürgen Glag is based in Düsseldorf 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. Jürgen Glag ist als Projektmanager bei einem großen Beratungsunternehmen in Düsseldorf beschäftigt. Seit über 15 Jahren arbeitet er im Bereich der Anwendungsentwicklung. Seine Arbeitsschwerpunkte liegen im Management von Projekten für die Versicherungswirtschaft sowie in der DB2-Beratung. Über Performance- und Tuningmaßnahmen hinsichtlich des Einsatzes von DB2 hat er auf Seminaren mehrfach Vorträge gehalten.