DB2 High Performance Design and Tuning - Richard Yevich , Susan... - Librairie Eyrolles
Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

DB2 High Performance Design and Tuning
Ajouter à une liste

Librairie Eyrolles - Paris 5e

DB2 High Performance Design and Tuning

DB2 High Performance Design and Tuning

Richard Yevich, Susan Lawson

697 pages, parution le 15/06/2000


Improve the performance of any IBM DB2 database with expert Version 6.x and 7.0 tuning techniques!
  • The only all-in-one, start-to-finish guide to maximizing DB2 performance!
  • Top 20 DB2 Performance Myths-and what to do about them
  • Includes exclusive, in-depth coverage of DB2 Versions 6.x and 7!
  • Tuning for the DB2 designers, developers and administrators
  • Design and tuning for robust e-commerce functionality

Foreword by Roger Miller, IBM Lead DB2 Strategist

This is the most comprehensive, practical DB2 optimization guide ever published! World-renowned DB2 consultants Richard Yevich and Susan Lawson cover all aspects of DB2 performance tuning: hardware, physical design, application coding, SQL, stored procedures, triggers, Java, and beyond. Review I/O, storage management, SMS usage, CPU tuning, memory tuning, and bufferpool design. Master every key DB2 database design optimization, including indexing, code and reference tables, and supporting the DB2 Catalog and Directory. Discover start-to-finish application development techniques proven to deliver outstanding performance, including commit strategies, application interfaces, and superior SQL coding techniques.

  • Top 20 DB2 Performance Myths—and what to do about them!
  • Based on hands-on experience at hundreds of DB2 installations
  • Includes hands-on, in-depth coverage of data sharing and DB2 Version 7!
  • For developers, designers, and DBAs

From OLAP to OLTP, e-business to high availability, troubleshooting to long-term monitoring, this book covers it all. You'll be amazed at how much more performance you can squeeze out of your DB2 system—with DB2 High Performance Development & Tuning!


  • 1. I/O and Storage Management.
  • 2. CPU.
  • 3. Memory.
  • 4. Catalog and Directory.
  • 5. Physical Database Objects.
  • 6. VLDBs, VLTBs, and Warehouses.
  • 7. Large Objects (LOBs).
  • 8. Special Tables.
  • 9. Roles in Database Implementation.
  • 10. General Application Design.
  • 11. Version 6 Late Additions and Version 7.
  • 12. Program Design and Processing.
  • 13. Locking and Concurrency.
  • 14. Temporary Tables.
  • 15. Enterprise Resource Planning.
  • 16. SQL.
  • 17. Triggers and User-Defined Functions.
  • 18. LOBs and Extenders.
  • 19. Stored Procedures.
  • 20. REXX, Java, and SQL Procedure Language.
  • 21. Parallelism.
  • 22. Predictive Analysis, Governing and Tuning.
  • 23. Influencing the Optimizer.
  • 24. E-Business, the Web, and Networks.
  • 25. Data Sharing Overview and Processing Costs.
  • 26. Hardware and Configuration Considerations.
  • 27. Locking.
  • 28. Group Buffer Pools.
  • 29. Migration.
  • 30. Application Tuning.
  • 31. Physical Design.
  • 32. Problem Diagnosing.
  • 33. Long-Term Monitoring.
  • Index.

L'auteur - Richard Yevich

Richard Yevich is an internationally recognized consultant and teacher and principal of YL&A, Inc., a firm specializing in consulting, performance audits, performance publications, and Web database software development which assists businesses in exploiting e-commerce technologies. An IBM Gold Consultant for DB2 and S/390, he co-authored Data Warehouse Practical Advice from the Experts (Prentice Hall PTR) and DB2 Answers, and is widely published in trade journals and magazines.

L'auteur - Susan Lawson

Susan Lawson, Principal Consultant with YL&A, has worked with DB2 for over a dozen years. She has served as an IBM Data Sharing advocate, supporting many large DB2 customers and providing technical expertise for migration to DB2 Data Sharing in Parallel Sysplex environments. Now a Director of the Midwest DB2 Users Group and IBM Gold Consultant for DB2 and S/390, she is Technical Editor of the IDUG Solutions Journal.

Caractéristiques techniques

Éditeur(s) Prentice Hall
Auteur(s) Richard Yevich, Susan Lawson
Parution 15/06/2000
Nb. de pages 697
Format 18 x 24
Couverture Relié
Poids 1595g
Intérieur Noir et Blanc
EAN13 9780132037952

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.