|
Understanding DB2: Learning Visually with Examples 2nd Edition Hardback
The Easy, Visual Way to Master IBM DB2??Fully Updated for Version 9.5
IBM 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
CONTENTS:
ForewordPrefaceAcknowledgmentsAbout the AuthorsChapter 1: Introduction to DB2Chapter 2: DB2 At a Glance??The Big PictureChapter 3: Installing DB2Chapter 4: Using the DB2 ToolsChapter 5: Understanding the DB2 Environment, DB2 Instances, and DatabasesChapter 6: Configuring Client and Server ConnectivityChapter 7: Working with Database ObjectsChapter 8: The DB2 Storage ModelChapter 9: Leveraging the Power of SQLChapter 10: Mastering the DB2 Native XML SupportChapter 11: Implementing SecurityChapter 12: Understanding Concurrency and LockingChapter 13: Maintaining DataChapter 14: Developing Database Backup and Recovery SolutionsChapter 15: The DB2 Process ModelChapter 16: The DB2 Memory ModelChapter 17: Database Performance ConsiderationsChapter 18: Diagnosing ProblemsAppendix A: Solutions to the Review QuestionsAppendix B: Use of Uppercase versus Lowercase in DB2Appendix C: IBM ServersAppendix D: Using the DB2 System Catalog TablesResourcesIndex
|
