Understanding DB2
Learning Visually with Examples
Raul Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
Résumé
The Easy, Visual Guide to IBM DB2 V8.2
IBM DB2 Universal Database V8.2 for Linux, UNIX, and Windows is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM.
Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.
For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations.
Coverage includes
- Understanding the DB2 product family, DB2 commands, and the DB2 environment
- Configuring client and server connectivity: walkthroughs of four typical scenarios
- Managing DB2 storage: partitions, tablespaces, buffer pools, and more
- Leveraging the power of SQL: queries, inserts, deletes, and updates
- Implementing security: encryption, authentication, and authorization
- Administering and maintaining data, from LOAD and EXPORT to backup/recovery
- Providing high availability with online split mirroring and suspended I/O
- DB2 architecture: process and memory models
- Managing database performance and troubleshooting
L'auteur - Raul Chong
Raul F. Chong is a DB2 information developer with the Application Development Solutions team at the IBM Toronto Lab. He is responsible for developing sample programs and DB2 documentation for Web Services and CLI.
L'auteur - Clara Liu
Clara Liu is a database consultant at IBM Canada. As a member of IBM's Channel and Partner Enablement Team, she works closely with partners, ISVs, and integrators to develop and tune third-party products for DB2. She coauthored DB2 SQL Procedure Language for Linux, UNIX and Windows (Prentice Hall, 2003) with Paul Yip.
L'auteur - Dwaine R. Snow
Dwaine R. Snow has twelve years of experience implementing and tuning DB2 to support workloads from Web-based transactions up to multiterabyte data warehouses. Snow is the product manager for DB2 partitioned databases and is co-author of The DB2 Cluster Certification Guide.
Sommaire
- Foreword
- Preface
- Acknowledgments
- About the Authors
- Introduction to DB2 UDB
- DB2 at a Glance: The Big Picture
- Installing DB2
- Using the DB2 Tools
- Understanding the DB2 Environment, DB2 Instances, and Databases
- Configuring Client and Server Connectivity
- Working with Database Objects
- The DB2 Storage Model
- Leveraging the Power of SQL
- Implementing Security
- Understanding Concurrency and Locking
- Maintaining Data
- Developing Database Backup and Recovery Solutions
- The DB2 Process Model
- The DB2 Memory Model
- Database Performance Considerations
- Diagnosing Problems
- Appendix A: Solutions to the Review Questions
- Appendix B: Use of Uppercase Versus Lowercase in BD2
- Appendix C: IBM servers
- Appendix D: Using the DB2 System Catalog Tables
- Appendix E: Setting Up Database Connectivity for DB2 UDB for z/OS and DB2 UDB for iSeries
- Appendix F: Diagnosing DB2 Connectivity Problems
- Resources
- Glossary
- Index
- About the CD-ROM
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | IBM Press |
| Auteur(s) | Raul Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow |
| Parution | 14/03/2005 |
| Nb. de pages | 896 |
| Format | 18 x 24 |
| Couverture | Relié |
| Poids | 1546g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780131859166 |
| ISBN13 | 978-0-13-185916-6 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
