… nicht ganz frisch, aber trotzdem noch gut! Die Autoren Susan Lawson and Dan Luksetich beschäftigen sich auf rund 100 Seiten ausgiebig mit allen Themen der DB2-Performacnce und untertiteln ihren Aufsatz mit „A Guideline to Achieving Best Performance with DB2„.

• Chapter 1 How DB2 manages performance
• The DB2 optimizer
• Access paths
• Read mechanisms
• Dynamic prefetch
• Sequential prefetch
• List prefetch
• Index lookaside
• Locking
• Lock avoidance
• Sorting
• Avoiding sorts
• DB2 catalog statistics
• Cardinality statistics
• Frequency distribution statistics
• Histogram statistics
• Buffer pools
• Parallelism
• Predicates and SQL tuning
• Types of DB2 predicates
• Combining predicates
• Boolean term predicates
• Predicate transitive closure
• Chapter 2 Coding Efficient SQL
• SQL performance tuning basics
• Performance data
• Execution metrics
• Explain data
• Object statistical data
• DB2 access path choices
• Tuning options
• Change the SQL
• Change the schema
• Collect up-to-date object statistics
• Conclusion
• Chapter 3 Index Analysis and Tuning
• When and how to design indexes
• Smart index design
• Partitioned and non-partitioned indexes
• Index impacts
• Avoiding too many indexes
• Tuning existing indexes
• Evaluating index usage
• Determining if another index is useful
• Index column sequence
• Tuning indexes with BMC solutions
• Chapter 4 Buffer pool tuning
• How buffer pools work
• Buffer pool performance factors
• Strategies for assigning buffer pools
• Managing buffer pools with BMC solutions
• BMC Pool Advisor for DB2
• Chapter 5 Subsystem tuning
• EDM pools
• RID pool
• Sort pool
• Miscellaneous DSNZPARMs
• DB2 catalog
• Locking and contention
• Managing DB2 subsystems with BMC solutions
• BMC System Performance for DB2
• Chapter 6 Designing databases and applications for performance
• Object creation guidelines
• Table space guidelines
• Referential integrity
• Free space
• Column data types
• Clustering indexes
• Locking and concurrency
• Lock sizes
• Concurrency
• Reduce I/O contention
• Coding efficient SQL
• Designing stored procedures for performance
• Design for performance with BMC solutions
• Managing physical database design
• Managing DB2 application design
• Chapter 7 Reorganization strategies
• DBA trends
• Tuning potential with reorganizations
• To reorganize or not to reorganize: that’s the question
• Step 1: Collect statistics
• Step 2: Select/Exclude objects
• Step 3: Analyze thresholds
• Reorganization strategies with BMC solutions
• BMC Database Performance for DB2