Muutke küpsiste eelistusi

Efficient Software Development with DB2 for OS/390: Organizational and Technical Measures for Performance Optimization 2nd ed. 1999 [Pehme köide]

Translated by , , Series edited by
  • Formaat: Paperback / softback, 150 pages, kõrgus x laius: 244x170 mm, kaal: 454 g, X, 150 p., 1 Paperback / softback
  • Sari: Efficient Software Development
  • Ilmumisaeg: 28-Oct-1999
  • Kirjastus: Friedrich Vieweg & Sohn Verlagsgesellschaft mbH
  • ISBN-10: 3528155876
  • ISBN-13: 9783528155872
Teised raamatud teemal:
Efficient Software Development with DB2 for OS/390: Organizational and Technical Measures for Performance Optimization 2nd ed. 1999Suurem pilt
  • Formaat: Paperback / softback, 150 pages, kõrgus x laius: 244x170 mm, kaal: 454 g, X, 150 p., 1 Paperback / softback
  • Sari: Efficient Software Development
  • Ilmumisaeg: 28-Oct-1999
  • Kirjastus: Friedrich Vieweg & Sohn Verlagsgesellschaft mbH
  • ISBN-10: 3528155876
  • ISBN-13: 9783528155872
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9783528155872.html
Märksõnad:
Jü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.

Muu info

Get the best out of DB2!
Introduction
1(4)
Why this Book?
1(2)
Target Groups
3(2)
Performance Problems: Symptoms, Causes, Measures
5(25)
Locking Problems
6(8)
Long Commit Intervals
6(1)
Executing Costly Operations
7(3)
Hot Spots
10(4)
Queuing Problems
14(2)
Similar Processing
14(2)
``Delivery Times Instead of Response Times'' in On-line Operation
16(7)
Too Many IOs
16(1)
Physical Sorting of Large Result Sets
17(1)
Costly Queries
18(2)
Large Indexes
20(1)
Low Selectivity of Indexes
21(2)
Excessively Long Runtimes in Batch
23(5)
Extensive Business
23(1)
Too Many Synchronous IOs
23(1)
Processing Logic
24(2)
Too Many Indexes
26(2)
Summary
28(2)
Organizational Measures in Software Development
30(27)
Application Scenario and Access Profile
31(3)
Application Scenario
32(1)
Access Profile
32(2)
Design of Critical Batch Runs
34(11)
Using Prefetch
35(4)
Load Procedure
39(6)
Access Modules
45(3)
Reducing Data Accesses
48(1)
Considerations Regarding the Application Architecture
49(1)
Standards for Software Development
50(2)
Programming Guidelines
50(1)
DB2 Manual
50(2)
Using Quality Assurance Tools
52(5)
Static Quality Requirements
52(2)
Dynamic Quality Requirements
54(2)
Usability Requirements on the QA Tool
56(1)
Case Studies
57(43)
Queues in On-line Operation
58(8)
Initial Situation
58(2)
Problem Description
60(1)
Approach
60(6)
Avoiding Hot-Spots
66(7)
Initial Situation
66(2)
Problem Description
68(1)
Approach
69(4)
Joins with Non-uniform Distribution of Attribute Values
73(6)
Initial Situation
73(2)
Problem Description
75(1)
Approach
75(4)
Formulation of Restart Keys in Cursors
79(3)
Initial Situation
79(1)
Problem Description
80(1)
Approach
81(1)
Reducing Synchronous IOs for Hierarchical Structures
82(10)
Initial Situation
82(3)
Problem Description
85(5)
Approach
90(2)
Comparison of LOAD and INSERT Procedures
92(8)
Initial Situation
92(2)
Problem Description
94(1)
Approach
94(6)
Tuning
100(11)
Unavoidable Tuning Measures
100(1)
Economical Procedure with ABC Analysis
101(1)
Sequence of the Activities
102(6)
First Step: Providing Information
102(1)
Second Step: Creating Access Profiles
102(1)
Third Step: Analysis of Access Profile and Explain
103(1)
Fourth Step: Analysis of the Tuning Candidates
103(5)
Expenditure for Tuning
108(1)
Effort Minimization for Future Tuning Measures
108(1)
Adjustment of the Procedure Model
109(1)
Staff Training
109(1)
Measuring the Tuning Results/Success
110(1)
Checklists
111(16)
Checklist for the Application Development
111(2)
Tasks of the Application Developers
111(1)
Avoidance of Costly Instructions
112(1)
Using Literature
112(1)
Knowledge of Programmers
112(1)
Further Problem Causes
112(1)
Tasks of a DBA Group
113(1)
Service for Application Development
113(1)
Defining Standards and Conventions
113(1)
Monitoring the Production Systems
113(1)
Quality Assurance
113(1)
Application Scenario
114(1)
Access Profile
115(2)
Checklist for System Design
117(2)
Application System
117(1)
Program Design
117(1)
Job Design
118(1)
Database Design
118(1)
Evaluating the DB2 Catalog for Critical Objects
119(6)
Critical Tables
119(3)
Critical Table Spaces
122(1)
Critical Indexes
122(2)
Critical Packages
124(1)
Inverting a Timestamp
125(2)
Some Additional Stuff for Application Development
127(20)
DML Extensions
127(11)
AS-Clause
127(3)
Case-Expression
130(3)
Join-Types
133(4)
Sysdummy1-Table
137(1)
DDL Extensions
138(9)
With Restrict on Drop clause
138(1)
Type 2 Indexes
139(1)
Row Level Locking
140(1)
UR - Uncommitted Read
141(2)
Stored Procedures
143(4)
Bibliography 147(1)
Index 148
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.