Administration Guide

How This Book is Structured

The Administration Guide contains information about the following major topics:

• "Introduction to Parallelism in DB2 Universal Database", presents an overview of DB2 Universal Database and the types of parallelism provided by DB2.

  Database Design and Implementation

• Chapter 1. "Designing Your Logical Database", discusses the concepts and guidelines for designing a logical database.

• Chapter 2. "Designing Your Physical Database", discusses the guidelines for designing a physical database, including considerations related to physical data storage.

• Chapter 3. "Implementing Your Design", discusses the concepts and guidelines for creating a database and the objects within a database.

• Chapter 4. "Controlling Database Access", describes how you can control access to your database's resources.

• Chapter 5. "Utilities for Moving Data", discusses the LOAD, AutoLoader, IMPORT and EXPORT utilities. db2move and replication are also discussed.

• Chapter 6. "Recovering a Database", discusses factors to consider when choosing database and table space recovery methods, including backing up and restoring a database or table space, and using the roll-forward recovery method.

  Distributed Transaction Processing

• Chapter 7. "Distributed Databases", discusses how you can access multiple databases in a single transaction.

• Chapter 8. "Using DB2 with an XA-Compliant Transaction Manager", discusses how you can use your databases in a distributed transaction processing environment such as CICS.

  Tuning Application Performance

• Chapter 9. "Application Considerations", describes some techniques for improving database performance when designing your applications.

• Chapter 10. "Environmental Considerations", describes some techniques for improving database performance when setting up your database environment.

• Chapter 11. "System Catalog Statistics", describes how statistics about your data can be collected and used to ensure optimal performance.

• Chapter 12. "Understanding the SQL Compiler", describes what happens to an SQL statement when it is compiled using the SQL compiler.

• Chapter 13. "SQL Explain Facility", describes the Explain facility, which allows you to examine the choices the SQL compiler has made to access your data.

  Tuning and Configuring Your System

• Chapter 14. "Operational Performance", provides an overview of how the database manager uses memory and other considerations that affect run-time performance.

• Chapter 15. "Using the Governor", provides an introduction to the use of a governor to control some aspects of database management.

• Chapter 16. "Redistributing Data Across Database Partitions", discusses the tasks required in a partitioned database environment to redistribute data across partitions.

• Chapter 17. "Scaling Your Configuration", introduces some considerations and tasks associated with increasing the size of your database systems.

• Chapter 18. "Benchmark Testing", provides an overview of benchmark testing and how to perform benchmark testing.

• Chapter 19. "Configuring DB2", discusses the database manager and database configuration files and the values for the configuration parameters.

  Appendixes

• Appendix A. "Planning Database Migration", provides information about migrating databases to Version 5.

• Appendix B. "Incompatibilities Between Releases", presents the incompatibilities introduced with Version 5.

• Appendix C. "Memory Usage for DB2 Universal Database Version 5", presents memory requirements for each DB2 feature.

• Appendix D. "Naming Rules", provides the rules to follow when naming databases and objects.

• Appendix E. "DB2 Registry Values and Environment Variables", presents profile registry values and environment variables.

• Appendix F. "Using Distributed Computing Environment (DCE) Directory Services", provides information about how you can use DCE Directory Services.

• Appendix G. "X/Open Distributed Transaction Processing Model", provides an overview of the X/Open Distributed Transaction Processing model and the DB2 database support provided.

• Appendix H. "Sample Tables", contains a description of the sample tables provided with the database manager.

• Appendix I. "Catalog Views", contains a description of each system catalog view, including column names and data types.

• Appendix J. "User Exit for Database Recovery", discusses how user exit programs can be used with database log files and describes some sample user exit programs.

• Appendix K. "Explain Tables and Definitions", provides information about the tables used by the DB2 Explain facility and how to create those tables.

• Appendix L. "SQL Explain Tools (db2expln and dynexpln)", provides information on using the DB2 explain tools: db2expln and dynexpln.

• Appendix M. "National Language Support (NLS)", introduces DB2 National Language Support (NLS) including information about countries, languages, and code pages.

• Appendix N. "Splitting Data with db2split", discusses how to use the db2split tool in a partitioned database environment.

• Appendix O. "Supplemental AutoLoader Information", presents supplmental AutoLoader information. AutoLoader is only for use in a partitioned database environment.

• Appendix P. "Issuing Commands to Multiple Database Partitions", discusses the use of the db2_all and rah shell scripts to send commands to all partitions in a partitioned database environment.

• Appendix Q. "Supporting High Availability Cluster Multi-Processing Configurations", discusses the support of IBM High Availability Cluster Multi-Processing (HACMP) for AIX by DB2.

[ DB2 List of Books | Search the DB2 Books ]