The Easy, Visual Way to Master IBM DB2®-Fully Updated for Version 9.5IBM DB2 V9.5 and V9 provide breakthrough capabilities for providing Information on Demand, implementing Web services and Service Oriented Architecture, and streamlining information management. Understanding DB2®: Learning Visually with Examples, Second Edition is the easiest way to master current versions of DB2 and apply their full power to your business challenges.
Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 V9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Each concept is presented with easy-to-understand screenshots, diagrams, charts, and tables.
This book is for everyone who works with DB2: DBAs, sysadmins, developers, and consultants. With hundreds of well-designed review questions and answers, it will also help professionals prepare for the IBM DB2 Certification Exams 730, 731, or 736.
Coverage includes
* Choosing the right version of DB2 for your needs
* Installing and configuring DB2
* Understanding the DB2 environment, instances, and databases
* Establishing client and server connectivity
* Working with database objects
* Utilizing breakthrough pureXMLTM technologies and native XML support
* Mastering administration, maintenance, performance optimization, troubleshooting, and recovery
* Understanding improvements in the DB2 process, memory, and storage models
* Implementing effective database security
* Leveraging the power of SQL
About the Author
Raul F. Chong is the DB2 on Campus Program Manager based at the IBM Toronto Laboratory. His main responsibility is to grow the DB2 Express community, helping members interact with one another and contributing to the forum. Raul is focusing on universities and other educational institutions promoting the DB2 on Campus program. Raul holds a B.S. in computer science from the University of Toronto, and is a DB2 Certified Solutions Expert in both DB2 Administration and Application Development. He is the lead author of the first edition of Understanding DB2: Learning Visually with Examples and is coauthor of DB2 SQL PL Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS.
Xiaomei Wang is a technical consultant for IBM Discovery & Enterprise Content Management (ECM) based at the IBM Toronto Laboratory. Xiaomei has presented at conferences worldwide, has written a number of articles, and coauthored the redbook SAP Solutions on IBM DB2 UDB V8.2.2 Handbook. She is an IBM Certified Solution Experts (Content Manager, FileNet P8, DB2 UDB Database Administration, DB2 UDB Application Development, DB2 UDB Advanced Technical Expert, and Business Intelligence), and also a Red Hat Certified Technician.
Michael Dang is a DB2 Technical Sales Specialist. He specializes in solution design, database sizing, product licensing, and Balanced Warehouse configurations. Michael has also worked as a DB2 Support Analyst, and as a DB2 Database Administrator for more than seven years. He has contributed to numerous articles and is an IBM Certified Advanced Technical Expert.
Dwaine R. Snow is a senior product manager for DB2 for Linux, UNIX, and Windows. Dwaine has worked with DB2 for the past seventeen years as part of the development team focusing on the database engine and tools, the development of the DB2 Certification program, and as part of the lab-based consulting team. Dwaine has presented at conferences worldwide, contributed to the DB2 tutorial series, and has written a number of articles and books on DB2 including Understanding DB2: Learning Visually with Examples, First Edition; Advanced DBA Certification Guide and Reference for DB2® Universal Database for Linux, UNIX, and Windows; DB2® UDB for Windows; The DB2® Cluster Certification Guide; and the second edition of the DB2® Certification Guide for Linux, UNIX, and Windows. Dwaine also helps write and review the product certification tests and holds all DB2 certifications.
