Understanding DB2 Learning Visually with Examples

book cover
• Table of Contents
• Index
Understanding DB2® Learning Visually with Examples
By Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
Publisher: Prentice Hall PTR
Pub Date: January 25, 2005
ISBN: 0-13-185916-1
Pages: 928

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

book cover
• Table of Contents
• Index
Understanding DB2® Learning Visually with Examples
By Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
Publisher: Prentice Hall PTR
Pub Date: January 25, 2005
ISBN: 0-13-185916-1
Pages: 928

   IBM Press
      DB2® Books
      On Demand Computing Books
      WebSphere Books
      More Books from IBM Press
      Who Should Read This Book?
      Getting Started
      A Word of Advice
      Contacting the Authors
   About the Authors
      Author Publications
       Chapter 1.  Introduction to DB2 UDB
      Section 1.1.  A Brief History of DB2
      Section 1.2.  DB2 software and the IBM E-Business On-Demand Model
      Section 1.3.  DB2 UDB Editions
      Section 1.4.  DB2 UDB Clients
      Section 1.5.  "Try and Buy" Versions
      Section 1.6.  Host Connectivity
      Section 1.7.  Federated Support
      Section 1.8.  Replication Support
      Section 1.9.  IBM DB2 Information Integrator
      Section 1.10.  Special Package Offerings for Developers
      Section 1.11.  DB2 Syntax Diagram Conventions
      Section 1.12.  Case Study
      Section 1.13.  Summary
      Section 1.14.  Review Questions
       Chapter 2.  DB2 at a Glance: The Big Picture
      Section 2.1.  SQL Statements and DB2 Commands
      Section 2.2.  DB2 Tools Overview
      Section 2.3.  The DB2 Environment
      Section 2.4.  Federation
      Section 2.5.  Case Study: The DB2 Environment
      Section 2.6.  Database Partitioning Feature
      Section 2.7.  Case Study: DB2 with DPF Environment
      Section 2.8.  Summary
      Section 2.9.  Review Questions
       Chapter 3.  Installing DB2
      Section 3.1.  DB2 Installation: The Big Picture
      Section 3.2.  Required User IDs and Groups
      Section 3.3.  Installing DB2 Using the DB2 Setup Wizard
      Section 3.4.  Silent Install Using a Response File
      Section 3.5.  Installing DB2 Manually (Linux/UNIX Only)
      Section 3.6.  Installing a DB2 License
      Section 3.7.  Installing DB2 in a DPF Environment
      Section 3.8.  Installing DB2 FixPaks
      Section 3.9.  Case Study
      Section 3.10.  Summary
      Section 3.11.  Review Questions
       Chapter 4.  Using the DB2 Tools
      Section 4.1.  DB2 Tools: The Big Picture
      Section 4.2.  The Command Line Tools
      Section 4.3.  Development Tools
      Section 4.4.  General Administration Tools
      Section 4.5.  Information Tools
      Section 4.6.  Monitoring Tools
      Section 4.7.  Setup Tools
      Section 4.8.  Other Tools
      Section 4.9.  Tool Settings
      Section 4.10.  Case Study
      Section 4.11.  Summary
      Section 4.12.  Review Questions
       Chapter 5.  Understanding the DB2 Environment, DB2 Instances, and Databases
      Section 5.1.  The DB2 Environment, DB2 Instances, and Databases: The Big Picture
      Section 5.2.  The DB2 Environment
      Section 5.3.  The DB2 Instance
      Section 5.4.  The Database Administration Server
      Section 5.5.  Configuring a Database
      Section 5.6.  Instance and Database Design Considerations
      Section 5.7.  Case Study
      Section 5.8.  Summary
      Section 5.9.  Review Questions
       Chapter 6.  Configuring Client and Server Connectivity
      Section 6.1.  Client and Server Connectivity: The Big Picture
      Section 6.2.  The DB2 Directories
      Section 6.3.  Supported Connectivity Scenarios
      Section 6.4.  Configuring Database Connections Using the Configuration Assistant
      Section 6.5.  Case Study
      Section 6.6.  Summary
      Section 6.7.  Review Questions
       Chapter 7.  Working with Database Objects
      Section 7.1.  DB2 Database Objects: The Big Picture
      Section 7.2.  Databases
      Section 7.3.  Partition Groups
      Section 7.4.  Table Spaces
      Section 7.5.  Buffer Pools
      Section 7.6.  Schemas
      Section 7.7.  Data Types
      Section 7.8.  Tables
      Section 7.9.  Indexes
      Section 7.10.  Multidimensional Clustering Tables and Block Indexes
      Section 7.11.  Views
      Section 7.12.  Packages
      Section 7.13.  Triggers
      Section 7.14.  Stored Procedures
      Section 7.15.  User-Defined Functions
      Section 7.16.  Sequences
      Section 7.17.  Case Study
      Section 7.18.  Summary
      Section 7.19.  Review Questions
       Chapter 8.  The DB2 Storage Model
      Section 8.1.  The DB2 Storage Model: The Big Picture
      Section 8.2.  Databases: Logical and Physical Storage of Your Data
      Section 8.3.  Database Partition Groups
      Section 8.4.  Table Spaces
      Section 8.5.  Buffer Pools
      Section 8.6.  Case Study
      Section 8.7.  Summary
      Section 8.8.  Review Questions
       Chapter 9.  Leveraging the Power of SQL
      Section 9.1.  Querying DB2 Data
      Section 9.2.  Modifying DB2 Data
      Section 9.3.  Selecting from UPDATE, DELETE, and INSERT
      Section 9.4.  The MERGE Statement
      Section 9.5.  Recursive SQL
      Section 9.6.  The UNION, INTERSECT, and EXCEPT Operators
      Section 9.7.  Case Study
      Section 9.8.  Summary
      Section 9.9.  Review Questions
       Chapter 10.  Implementing Security
      Section 10.1.  DB2 Security Model: The Big Picture
      Section 10.2.  Authentication
      Section 10.3.  Data Encryption
      Section 10.4.  Administrative Authorities
      Section 10.5.  Database Object Privileges
      Section 10.6.  Authority and Privilege Metadata
      Section 10.7.  Windows Domain Considerations
      Section 10.8.  Case Study
      Section 10.9.  Summary
      Section 10.10.  Review Questions
       Chapter 11.  Understanding Concurrency and Locking
      Section 11.1.  DB2 Locking and Concurrency: The Big Picture
      Section 11.2.  Concurrency and Locking Scenarios
      Section 11.3.  DB2 Isolation Levels
      Section 11.4.  Changing Isolation Levels
      Section 11.5.  DB2 Locking
      Section 11.6.  Diagnosing Lock Problems
      Section 11.7.  Techniques to Avoid Locking
      Section 11.8.  Case Study
      Section 11.9.  Summary
      Section 11.10.  Review Questions
       Chapter 12.  Maintaining Data
      Section 12.1.  DB2 Data Movement Utilities: The Big Picture
      Section 12.2.  Data Movement File Formats
      Section 12.3.  The DB2 EXPORT Utility
      Section 12.4.  The DB2 IMPORT Utility
      Section 12.5.  The DB2 LOAD Utility
      Section 12.6.  The db2move Utility
      Section 12.7.  The db2relocatedb Utility
      Section 12.8.  Generating Data Definition Language
      Section 12.9.  DB2 Maintenance Utilities
      Section 12.10.  Case Study
      Section 12.11.  Summary
      Section 12.12.  Review Questions
       Chapter 13.  Developing Database Backup and Recovery Solutions
      Section 13.1.  Database Recovery Concepts
      Section 13.2.  DB2 Transaction Logs
      Section 13.3.  Recovery Terminology
      Section 13.4.  Performing Database and Table Space Backups
      Section 13.5.  Database and Table Space Recovery Using the RESTORE DATABASE Command
      Section 13.6.  Database and Table Space Roll Forward
      Section 13.7.  Recovering a Dropped Table
      Section 13.8.  The Recovery History File
      Section 13.9.  Database Recovery Using the RECOVER DATABASE Command
      Section 13.10.  High Availability Through Online Split Mirroring and Suspended I/O Support
      Section 13.11.  High Availability Disaster Recovery
      Section 13.12.  Using DB2 Tools to Inspect the Health of Your Database
      Section 13.13.  Case Study
      Section 13.14.  Summary
      Section 13.15.  Review Questions
       Chapter 14.  The DB2 Process Model
      Section 14.1.  The DB2 Process Model: The Big Picture
      Section 14.2.  The DB2 Engine Dispatchable Units
      Section 14.3.  Tuning the Number of EDUs
      Section 14.4.  Monitoring and Tuning the DB2 Agents
      Section 14.5.  The Connection Concentrator
      Section 14.6.  Commonly Seen DB2 Executables
      Section 14.7.  Additional Services/Processes on Windows
      Section 14.8.  Case Study
      Section 14.9.  Summary
      Section 14.10.  Review Questions
       Chapter 15.  The DB2 Memory Model
      Section 15.1.  DB2 Memory Allocation: The Big Picture
      Section 15.2.  Instance-Level Shared Memory
      Section 15.3.  Database-Level Shared Memory
      Section 15.4.  Application-Level Shared Memory
      Section 15.5.  Agent-Level Private Memory
      Section 15.6.  The Memory Model
      Section 15.7.  32-Bit Memory Model Considerations
      Section 15.8.  64-Bit Memory Model Considerations
      Section 15.9.  AWE Support with Windows
      Section 15.10.  Case Study
      Section 15.11.  Summary
      Section 15.12.  Review Questions
       Chapter 16.  Database Performance Considerations
      Section 16.1.  Performance Fundamentals
      Section 16.2.  System/Server Configuration
      Section 16.3.  The DB2 Configuration Advisor
      Section 16.4.  Configuring the DB2 Instance
      Section 16.5.  Configuring Your Databases
      Section 16.6.  Lack of Proper Maintenance
      Section 16.7.  The Snapshot Monitor
      Section 16.8.  Event Monitors
      Section 16.9.  The DB2 Optimizer
      Section 16.10.  The Explain Tool and Explain Tables
      Section 16.11.  Using Visual Explain to Examine Access Plans
      Section 16.12.  Case Study
      Section 16.13.  Summary
      Section 16.14.  Review Questions
       Chapter 17.  Diagnosing Problems
      Section 17.1.  Problem Diagnosis: The Big Picture
      Section 17.2.  How Does DB2 Report Problems?
      Section 17.3.  DB2 Error Message Description
      Section 17.4.  DB2 First-Failure Data Capture
      Section 17.5.  Receiving E-mail Notifications
      Section 17.6.  The db2support Tool
      Section 17.7.  The DB2 Trace Facility
      Section 17.8.  Searching for Known Problems
      Section 17.9.  Case Study
      Section 17.10.  Summary
      Section 17.11.  Review Questions
       Appendix A.  Solutions to the Review Questions
      Chapter 1
      Chapter 2
      Chapter 3
      Chapter 4
      Chapter 5
      Chapter 6
      Chapter 7
      Chapter 8
      Chapter 9
      Chapter 10
      Chapter 11
      Chapter 12
      Chapter 13
      Chapter 14
      Chapter 15
      Chapter 16
      Chapter 17
       Appendix B.  Use of Uppercase Versus Lowercase in DB2
       Appendix C.  IBM Servers
       Appendix D.  Using the DB2 System Catalog Tables
      DB2 System Catalog Tables
      How to Extract Information from the System Catalog Tables
      How to Use the SYSSTAT Tables to Perform What-if Modeling and Analysis
       Appendix E.  Setting Up Database Connectivity for DB2 UDB for z/OS and DB2 UDB for iSeries
      Part I: Setting Up Database Connectivity for DB2 UDB for z/OS
      Part II: Setting Up Database Connectivity for DB2 UDB for iSeries
       Appendix F.  Diagnosing DB2 Connectivity Problems
      Diagnosing Client-Server TCP/IP Connection Problems
       About the CD-ROM
       CD-ROM Warranty