| | Copyright |
| | IBM Press SeriesInformation Management |
| | About Prentice Hall Professional Technical Reference |
| | Foreword |
| | Preface |
| | | DB2: Any Workload, Any Data, All the Time |
| | | Conventions Used Throughout the Book |
| | | Acknowledgments |
| | | Trademarks |
|
| | Chapter 1. Data Storage |
| | | Some Terminology Used in DB2 |
| | | The Default Database |
| | | Table Spaces |
| | | Additional Table Space Options/Parameters |
| | | Summary |
|
| | Chapter 2. Data Manipulation |
| | | The Buffer Pools |
| | | Parallelism |
| | | Types of Database Objects |
| | | Summary |
|
| | Chapter 3. Database Availability |
| | | Ability to Manage Logs |
| | | Developing a Backup and Recovery Strategy |
| | | Backup Overview |
| | | Restore Overview |
| | | Rollforward Overview |
| | | High Availability Clustering |
| | | Availability Enhancements |
| | | Ability to Use db2dart |
| | | Summary |
|
| | Chapter 4. Database Security |
| | | Selecting User Names and Group Names for DB2 Installation |
| | | Authentication Methods |
| | | Privileges, Authorities, and Authorizations |
| | | Firewall Support |
| | | What Is LDAP? |
| | | Security Implementation and Usage |
| | | How DB2 for Windows NT/2000 Works with Windows NT/2000 Security |
| | | User Authentication with DB2 for Windows NT |
| | | Summary |
|
| | Chapter 5. Multi-Dimensional Clustering |
| | | MDC Terminology |
| | | Design Guidelines for MDC Tables |
| | | MDC Performance Guidelines |
| | | Space Usage with MDC Tables |
| | | MDC Indexes |
| | | Summary |
|
| | Chapter 6. The DB2 Optimizer |
| | | Joining in DB2 UDB |
| | | Materialized Query Tables |
| | | Understanding DB2 Query Access Plans |
| | | Summary |
|
| | Chapter 7. Federated Database Access |
| | | What Is a Federated System? |
| | | Overview of the Tasks to Set Up a Federated System |
| | | How Do You Interact with a Federated System? |
| | | Setting Up the Federated Server and Database |
| | | Working with the Federated Data |
| | | Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun Solaris |
| | | Configuration of a Federated Database System |
| | | Nickname Characteristics Affecting Global Optimization |
| | | Summary |
|
| | Chapter 8. Performance Tuning |
| | | Performance Fundamentals |
| | | Configuration Parameter Tuning |
| | | Database Configuration Parameter Tuning and Monitoring |
| | | Registry Variable Tuning |
| | | Other Important Configuration Parameters |
| | | Summary |
|
| | Chapter 9. Database Communications |
| | | Database Partition Configuration File (db2nodes.cfg) |
| | | Default Port Range |
| | | Non-Partitioned Database Environment |
| | | Installing the DB2 Server |
| | | Partitioned Database Environment |
| | | Post-Installation Setup |
| | | Installing and Configuring DB2 Client to DB2 Server Communications |
| | | Installing and Configuring DB2 Client to DB2 Host Communications |
| | | Installing DB2 Connect Personal Edition |
| | | Configuring DB2 Clients in a Two-Tier Environment |
| | | Configuring DB2 Clients in a Three-Tier Environment |
| | | FCM Communication Buffers Considerations |
| | | Summary |
|
| | Chapter 10. Performance Tuning Examples |
| | | Example 1: Create Index Taking Too Long |
| | | Example 2: Unable to Get Desired Throughput |
| | | Example 3: Query1 Taking Too Long to Run |
| | | Example 4: Query2 Taking Too Long to Run |
| | | Example 5: Periodic Noticeable Slowdown of Database Response Time |
|
| | Appendix A. Useful DB2 Commands |
| | | System Commands |
| | | CLP Commands |
| | | ONLINE Utility |
|
| | Appendix B. parseSQL.pl |
| | Appendix C. exfmtDIF.pl |
| | Appendix D. Comparing Index Advisor Recommended Indexes with Existing Indexes |
| | Appendix E. Configuration Parameters That Can Be Changed Online |
| | Appendix F. Explain Tools |
| | | EXPLAIN Tables |
| | | EXPLAIN Commands |
| | | EXPLAIN Output |
|
| | Appendix G. Starting and Stopping a DB2 Instance |
| | Appendix H. LDAP Integration in DB2 UDB Using Microsoft Active Directory |
| | | Implementation Guidelines |
|
| | Appendix I. Tuning DB2 UDB in the IBM LDAP Environment |
| | Appendix J. DB2 Support Information |
| | | DB2 Support Resources |
| | | Opening a PMR |
| | | Collecting Diagnostic Information |
| | | Sending Diagnostic Information |
|
| | Appendix K. DB2 Connect Implementation |
| | | Installing DB2 Connect Enterprise Edition |
|
| | Appendix L. Sample Questions |
| | Appendix M. Answers to Sample Questions |
| | About the CD-ROM |
| | | License Agreement |
| | | Technical Support |
|
| | Article |