| |
| |
| Foreword | |
| |
| |
| Preface | |
| |
| |
| |
| What's New | |
| |
| |
| Product Changes | |
| |
| |
| Manageability Enhancements | |
| |
| |
| Performance Enhancements | |
| |
| |
| Availability Enhancements | |
| |
| |
| Serviceability Enhancements | |
| |
| |
| Application Development Enhancements | |
| |
| |
| Summary | |
| |
| |
| |
| DB2 v8 Product Overview and Architecture | |
| |
| |
| Enterprise Server Edition | |
| |
| |
| DB2 Workgroup Server Edition (WSE) | |
| |
| |
| DB2 Personal Edition (PE) | |
| |
| |
| DB2 Universal Developers Edition (UDE) | |
| |
| |
| DB2 Personal Developers Edition (PDE) | |
| |
| |
| DB2 Warehouse Manager | |
| |
| |
| DB2 Intelligent Miner Products | |
| |
| |
| DB2 Spatial Extender | |
| |
| |
| DB2 Net Search Extender | |
| |
| |
| New Client | |
| |
| |
| DB2 Architecture | |
| |
| |
| Bufferpools | |
| |
| |
| Prefetchers (db2pfchr) | |
| |
| |
| Page Cleaners (db2pclnr) | |
| |
| |
| Logs (db2loggr) | |
| |
| |
| Deadlock Detector | |
| |
| |
| Connection Concentrator | |
| |
| |
| Summary | |
| |
| |
| |
| Logical and Physical Design | |
| |
| |
| Business Model | |
| |
| |
| Business Entities | |
| |
| |
| Business Rules | |
| |
| |
| Entities and Relationships | |
| |
| |
| Special Entity Relationships | |
| |
| |
| Normalization | |
| |
| |
| First Normal Form | |
| |
| |
| Second Normal Form | |
| |
| |
| Third Normal Form (3NF) | |
| |
| |
| Boyce-Codd Normal Form (BCNF) | |
| |
| |
| Domain Key/Normal Form (DK/NF) | |
| |
| |
| Unified Modeling Language (UML) | |
| |
| |
| Logical Design Outputs | |
| |
| |
| Physical Design | |
| |
| |
| Denormalization | |
| |
| |
| Creation of Indexes | |
| |
| |
| Creation of Tablespaces and Tables | |
| |
| |
| Bufferpool Strategy | |
| |
| |
| Summary | |
| |
| |
| |
| Application Development | |
| |
| |
| Getting Started | |
| |
| |
| DB2 Administration Client | |
| |
| |
| DB2 Application Development Client | |
| |
| |
| DB2 Personal Developers' Edition (PDE) | |
| |
| |
| DB2 Universal Developers' Edition | |
| |
| |
| DB2 Development Center | |
| |
| |
| DB2 Visual Explain | |
| |
| |
| Development Center | |
| |
| |
| Java Thread-Safe Routines | |
| |
| |
| Java Common Client | |
| |
| |
| SQL Enhancements | |
| |
| |
| SQL Assist | |
| |
| |
| SQL Enhancements | |
| |
| |
| Informational Constraints | |
| |
| |
| Insert Through Union All Views | |
| |
| |
| Summary Tables | |
| |
| |
| Current Refresh Age Special Register | |
| |
| |
| Materialized Query Table (MQT) | |
| |
| |
| User-Maintained MQTs | |
| |
| |
| eXtensible Markup Language | |
| |
| |
| Summary | |
| |
| |
| |
| Type-2 Indexes and Multidimensional Clustering | |
| |
| |
| Benefits of Type-2 Indexes | |
| |
| |
| Type-2 Indexes and Next-Key Locking | |
| |
| |
| Migration Considerations for Type-2 Indexes | |
| |
| |
| Suggested Migration Strategy for Type-2 Indexes | |
| |
| |
| Multidimensional Clustering | |
| |
| |
| MDC Table Considerations | |
| |
| |
| Summary | |
| |
| |
| |
| High Performance Tablespace Design and I/O Strategies | |
| |
| |
| Tablespaces | |
| |
| |
| Storage Models | |
| |
| |
| Prefetching | |
| |
| |
| Tables and Tablespace Considerations | |
| |
| |
| The Life of an I/O Request | |
| |
| |
| Redundant Array of Independent Disks (RAID) | |
| |
| |
| Tablespace Container Management | |
| |
| |
| DB2 and IBM Enterprise Storage System (ESS SHARK) | |
| |
| |
| Keeping a Map of Your Database | |
| |
| |
| Summary | |
| |
| |
| |
| Utilities and Commands | |
| |
| |
| Reorganizing Indexes/Tables | |
| |
| |
| REORGCHK Utility | |
| |
| |
| Database Logging | |
| |
| |
| Backup Database Utility | |
| |
| |
| Restore Database Utility | |
| |
| |
| Roll-forward Database | |
| |
| |
| Query Status | |
| |
| |
| Archive Log Command | |
| |
| |
| List History | |
| |
| |
| List Tablespaces | |
| |
| |
| Set Tablespace Containers Command | |
| |
| |
| DB2TBST-Get Tablespace State Command | |
| |
| |
| RUNSTATS Utility | |
| |
| |
| LOAD Utility | |
| |
| |
| LOAD QUERY Command | |
| |
| |
| QUIESCE Command | |
| |
| |
| UNQUIESCE Command | |
| |
| |
| Migrate Database Utility | |
| |
| |
| INSPECT Utility | |
| |
| |
| Summary | |
| |
| |
| |
| Tuning Bufferpools | |
| |
| |
| Introduction | |
| |
| |
| Maintaining Bufferpools | |
| |
| |
| Monitoring Bufferpool Performance | |
| |
| |
| Monitoring and Tuning Tables, Bufferpools, and Tablespaces | |
| |
| |
| Summary | |
| |
| |
| |
| Tuning Configuration Parameters | |
| |
| |
| Autonomic Computing | |
| |
| |
| Online Configuration Parameters | |
| |
| |
| DB2 Memory Areas | |
| |
| |
| Database Manager Shared Memory | |
| |
| |
| Database Global Memory | |
| |
| |
| Application Global Memory (app_ctl_heap_sz) | |
| |
| |
| Agent Private Memory | |
| |
| |
| Agent Parameters | |
| |
| |
| MAXAGENTS | |
| |
| |
| MAXCAGENTS | |
| |
| |
| MAXAPPLS | |
| |
| |
| Agent Monitoring | |
| |
| |
| Configuration Advisor | |
| |
| |
| Summary | |
| |
| |
| |
| Monitoring | |
| |
| |
| Enabling Monitoring | |
| |
| |
| Snapshots through New SQL Functions | |
| |
| |
| Event Monitoring | |
| |
| |
| Create Event Monitor Options | |
| |
| |
| Table Options | |
| |
| |
| Event Monitor Scope | |
| |
| |
| Event Monitor Catalog Tables | |
| |
| |
| General Consideration for Write-to-Table Event Monitors | |
| |
| |
| Summary | |
| |
| |
| |
| Problem Determination | |
| |
| |
| Connectivity Problems | |
| |
| |
| Performance and Application Problems | |
| |
| |
| DB2 Code (Defect) Problems | |
| |
| |
| DB2 Problem Determination Aids | |
| |
| |
| DB2DIAG | |
| |
| |
| LOG File | |
| |
| |
| DB2DIAG | |
| |
| |
| LOG SQLCA Entries | |
| |
| |
| DB2 Administration Notification Log | |
| |
| |
| System Logs | |
| |
| |
| CLI Trace | |
| |
| |
| DB2 Trace | |
| |
| |
| DRDA Trace | |
| |
| |
| Dumps | |
| |
| |
| Traps | |
| |
| |
| Call Stack Traces | |
| |
| |
| Sending Information to DB2 Support | |
| |
| |
| Summary | |
| |
| |
| |
| Understanding and Tuning DB2 Sort | |
| |
| |
| DB2 Sort Memory Areas | |
| |
| |
| Types of | |