| | | Copyright |
| | | IBM Press |
| | | | DB2® Books |
| | | | On Demand Computing Books |
| | | | WebSphere Books |
| | | | More Books from IBM Press |
| | | Foreword |
| | | Preface |
| | | | Who Should Read This Book? |
| | | | Getting Started |
| | | | A Word of Advice |
| | | | Conventions |
| | | | Contacting the Authors |
| | | Acknowledgments |
| | | 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 |
| | | Resources |
| | | Glossary |
| | | | A |
| | | | B |
| | | | C |
| | | | D |
| | | | E |
| | | | F |
| | | | G |
| | | | H |
| | | | I |
| | | | J |
| | | | K |
| | | | L |
| | | | M |
| | | | N |
| | | | O |
| | | | P |
| | | | Q |
| | | | R |
| | | | S |
| | | | T |
| | | | U |
| | | | V |
| | | | W |
| | | | X |
| | | | Z |
| | | About the CD-ROM |
| | | CD-ROM Warranty |
| | | Index |