You are previewing DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition.
O'Reilly logo
DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

Book Description

The Easy, Visual Introduction to IBM DB2 Version 10.5 for Linux, UNIX, and Windows

Foreword by Judy Huber, Vice President, Distributed Data Servers and Data Warehousing; Director, IBM Canada Laboratory

This book covers everything you need to get productive with the latest version of IBM DB2 and apply it to today’s business challenges. It discusses key features introduced in DB2 Versions 10.5, 10.1, and 9.7, including improvements in manageability, integration, security, Big Data support, BLU Acceleration, and cloud computing.

DB2 Essentials illuminates key concepts with examples drawn from the authors’ extensive experience with DB2 in enterprise environments. Raul F. Chong and Clara Liu explain how DB2 has evolved, what’s new, and how to choose the right products, editions, and tools. Next, they walk through installation, configuration, security, data access, remote connectivity, and day-to-day administration.

Each chapter starts with an illustrative overview to introduce its key concepts using a big picture approach. Clearly explained figures are used extensively, and techniques are presented with intuitive screenshots, diagrams, charts, and tables. Case studies illustrate how “theory” is applied in real-life environments, and hundreds of review questions help you prepare for IBM’s newest DB2 certification exams.

Coverage includes
• Understanding the role of DB2 in Big Data
• Preparing for and executing a smooth installation or upgrade
• Understanding the DB2 environment, instances, and databases
• Configuring client and server connectivity
• Working with database objects
• Getting started with BLU Acceleration
• Implementing security: authentication and authorization
• Understanding concurrency and locking
• Maintaining, backing up, and recovering data
• Using basic SQL in DB2 environments
• Diagnosing and solving DB2 problems

This book is for anyone who plans to work with DB2, including DBAs, system administrators, developers, and consultants. It will be a great resource whether you’re upgrading from an older version of DB2, migrating from a competitive database, or learning your first database platform.


Table of Contents

  1. About This eBook
  2. Title Page
  3. Copyright Page
  4. Dedication Page
  5. Contents at a Glance
  6. Contents
  7. Foreword
  8. Preface
    1. Who Should Read This Book?
    2. Getting Started
    3. A Word of Advice
    4. Conventions
    5. Contacting the Authors
    6. What’s New
    7. DB2 9.7
    8. DB2 9.8
    9. DB2 10.1
    10. DB2 10.5
  9. Acknowledgments
  10. About the Authors
  11. Chapter 1. Introduction to DB2
    1. A Brief History of DB2: From Past to Present
    2. The Role of DB2 in the Big Data World
    3. DB2 Editions
    4. IBM Data Server Clients and Driver Packages
    5. Mainframe Host Connectivity
    6. Database Federation Support
    7. Database Replication Support
    8. DB2 Syntax Diagram Conventions
    9. Case Study
    10. Summary
    11. Review Questions
  12. Chapter 2. DB2 at a Glance: The Big Picture
    1. SQL Statements, XQuery Statements, and DB2 Commands
    2. Database Tools and Utilities
    3. The DB2 Environment
    4. Database Partitioning
    5. DB2 pureScale
    6. Database Federation
    7. Use of Uppercase Versus Lowercase in DB2
    8. Case Study
    9. Summary
    10. Review Questions
  13. Chapter 3. Installing DB2
    1. DB2 Installation: The Big Picture
    2. DB2 Installation System Requirements
    3. Installing DB2 Using the DB2 Setup Wizard
    4. Root and Non-Root Installation on Linux and UNIX
    5. Required User IDs and Groups
    6. Silent Install Using a Response File
    7. Advanced DB2 Installation Methods (Linux and UNIX Only)
    8. Installing a DB2 License
    9. Reducing DB2 Product Installation Image Size
    10. Installing Multiple DB2 Versions and Fix Packs on the Same Server
    11. Installing DB2 Fix Packs
    12. Upgrading to the Latest DB2 Version
    13. Case Study 1
    14. Case Study 2
    15. Summary
    16. Review Questions
  14. Chapter 4. Using Database Tools and Utilities
    1. Database Tools: The Big Picture
    2. The Command-Line Tools
    3. IBM Data Studio
    4. IBM Data Studio Web Console
    5. Set-Up Tools
    6. Information Tools
    7. Problem Determination Tools
    8. Case Study 1
    9. Case Study 2
    10. Summary
    11. Review Questions
  15. Chapter 5. Understanding the DB2 Environment, DB2 Instances, and Databases
    1. The DB2 Environment, DB2 Instances, and Databases: The Big Picture
    2. The DB2 Instance
    3. The Database Administration Server (DAS)
    4. Configuring a Database
    5. The Configuration Advisor
    6. Design Considerations for Instances and Databases
    7. Case Study
    8. Summary
    9. Review Questions
  16. Chapter 6. Configuring Client and Server Connectivity
    1. Client and Server Connectivity: The Big Picture
    2. The DB2 Database Directories
    3. Supported Connectivity Scenarios
    4. Diagnosing DB2 Connectivity Problems
    5. Case Study
    6. Summary
    7. Review Questions
  17. Chapter 7. Working with Database Objects
    1. Database Objects: The Big Picture
    2. Databases
    3. Partition Groups
    4. Table Spaces
    5. Buffer Pools
    6. Schemas
    7. Data Types
    8. Tables
    9. Indexes
    10. Multidimensional Clustering (MDC) Tables and Block Indexes
    11. Combining Database Partitioning, Table Partitioning, and MDC
    12. Views
    13. Packages
    14. Triggers
    15. Stored Procedures
    16. User-Defined Functions
    17. Sequences
    18. Modules
    19. Case Study 1
    20. Case Study 2
    21. Summary
    22. Review Questions
  18. Chapter 8. Implementing Security
    1. DB2 Security Model: The Big Picture
    2. Authentication Methods
    3. Administrative Authorities
    4. Database Object Privileges
    5. Data Encryption
    6. Label-Based Access Control (LBAC)
    7. Row and Column Access Control (RCAC)
    8. Trusted Contexts
    9. Windows Security Considerations
    10. Authority and Privilege Metadata
    11. Case Study
    12. Summary
    13. Review Questions
  19. Chapter 9. Understanding Concurrency and Locking
    1. DB2 Locking and Concurrency: The Big Picture
    2. Concurrency and Locking Scenarios
    3. DB2 Isolation Levels
    4. Changing Isolation Levels
    5. DB2 Locking
    6. Diagnosing Lock Problems
    7. Techniques to Avoid Locking
    8. Case Study
    9. Exercises
    10. Summary
    11. Review Questions
  20. Chapter 10. Maintaining, Backing Up, and Recovering Data
    1. DB2 Data Movement Utilities: The Big Picture
    2. Generating Data Definition Language
    3. DB2 Maintenance Utilities: The Big Picture
    4. Database Backup, Recovery, and Roll Forward Concepts: The Big Picture
    5. Case Study
    6. Summary
    7. Review Questions
  21. Appendix A. Solutions to the Review Questions
    1. Chapter 1 Answers
    2. Chapter 2 Answers
    3. Chapter 3 Answers
    4. Chapter 4 Answers
    5. Chapter 5 Answers
    6. Chapter 6 Answers
    7. Chapter 7 Answers
    8. Chapter 8 Answers
    9. Chapter 9 Answers
    10. Chapter 10 Answers
  22. Appendix B. Introduction to SQL
    1. Querying DB2 Data
    2. Modifying Table Data
    3. Recursive SQL Statements
  23. Appendix C. A Comparison of DB2 and Oracle Terminology
    1. Product and Functionality Mapping
    2. Terminology Mapping
    3. DB2 Compatibility Features
    4. IBM Database Conversion Workbench
  24. Appendix D. Diagnosing Problems
    1. Problem Diagnosis: The Big Picture
    2. The Help (?) Command
    3. DB2 First Occurrence Data Capture (FODC)
    4. Tools for Troubleshooting
    5. Searching for Known Problems
  25. Appendix E. Resources
  26. Index