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.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.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.5. Case Study: The DB2 Environment
Section 2.6. Database Partitioning Feature
Section 2.7. Case Study: DB2 with DPF Environment
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.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.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.4. The Database Administration Server
Section 5.5. Configuring a Database
Section 5.6. Instance and Database Design Considerations
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
Chapter 7. Working with Database Objects
Section 7.1. DB2 Database Objects: The Big Picture
Section 7.10. Multidimensional Clustering Tables and Block Indexes
Section 7.14. Stored Procedures
Section 7.15. User-Defined Functions
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
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.6. The UNION, INTERSECT, and EXCEPT Operators
Chapter 10. Implementing Security
Section 10.1. DB2 Security Model: The Big Picture
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.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.6. Diagnosing Lock Problems
Section 11.7. Techniques to Avoid Locking
Section 11.10. Review Questions
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.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.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.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.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.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.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.11. Review Questions
Appendix A. Solutions to the Review Questions
Appendix B. Use of Uppercase Versus Lowercase in DB2
Appendix D. Using the 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