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. "Auditing DB2 Activities", describes how you can detect and monitor unwanted or unanticipated access to data.

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

• Chapter 7. "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 8. "Distributed Databases", discusses how you can access multiple databases in a single transaction.

• Chapter 9. "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 10. "Application Considerations", describes some techniques for improving database performance when designing your applications.

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

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

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

• Chapter 14. "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 15. "Operational Performance", provides an overview of how the database manager uses memory and other considerations that affect run-time performance.

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

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

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

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

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

  High Availability Systems

• Chapter 21. "High Availability Cluster Multi-Processing (HACMP) on AIX", discusses the support of IBM High Availability Cluster Multi-Processing (HACMP) for AIX by DB2.

• Chapter 22. "High Availability Cluster Multi-Processing, Enhanced Scalability (HACMP ES) for AIX", discusses the support of IBM High Availability Cluster Multi-Processing, Enhanced Scalability (HACMP ES) for AIX by DB2.

• Chapter 23. "High Availability in the Windows NT Environment", discusses the support of Microsoft Cluster Server for Windows NT by DB2.

• Chapter 24. "High Availability in the Solaris Operating Environment, Single-Partition Database", discusses the support of Sun Cluster 2.1 for the Sun Solaris Operating System by DB2.

• Chapter 25. "High Availability in the Solaris Operating Environment, Partitioned Database", discusses the support of Sun Cluster 2.1 for the Sun Solaris Operating System by DB2 Extended Enterprise Edition.

  Appendixes

• Appendix A. "How the DB2 Library Is Structured", provides information about the structure of the DB2 library, including SmartGuides, online help, messages, and books.

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

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

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

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

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

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

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

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

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

• Appendix L. "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 M. "Explain Tables and Definitions", provides information about the tables used by the DB2 Explain facility and how to create those tables.

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

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

• Appendix P. "Splitting Data with db2split", describes how to use the db2split utility to partition data and create partitioning maps.

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

• Appendix R. "How DB2 for Windows NT Works with Windows NT Security", describes how DB2 works with Windows NT security.

• Appendix S. "Configuring Multiple Logical Nodes", describes how to configure multiple logical nodes in a partitioned database environment.

• Appendix T. "Using Virtual Interface Architecture (VIA)", describes how to enable Virtual Interface Architecture for use with DB2 Extended Enterprise Edition in the Windows NT environment.

[ DB2 List of Books | Search the DB2 Books ]