Administration Guide
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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]