E-Book, Deutsch, 150 Seiten, eBook
Glag Efficient Software Development with DB2 for OS/390
1998
ISBN: 978-3-322-93863-3
Verlag: Vieweg & Teubner
Format: PDF
Kopierschutz: 1 - PDF Watermark
Organizational and Technical Measures for Performance Optimization
E-Book, Deutsch, 150 Seiten, eBook
Reihe: Efficient Software Development
ISBN: 978-3-322-93863-3
Verlag: Vieweg & Teubner
Format: PDF
Kopierschutz: 1 - PDF Watermark
Zielgruppe
Research
Weitere Infos & Material
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.