Administration Guide

How This Book is Structured

This book contains information about the following major topics:

The World of DB2 Universal Database

• Chapter 1, "Administering DB2 Universal Database", presents an introduction to, and overview of, DB2 Universal Database.

  Database Concepts

• Chapter 2, "Basic Relational Database Concepts", presents an overview of database objects, including recovery objects, storage objects, and system objects.
• Chapter 3, "Federated Systems", discusses federated systems, which are database management systems (DBMSs) that support applications and users submitting SQL statements referencing two or more DBMSs or databases in a single statement.
• Chapter 4, "Parallel Database Systems", provides an introduction to the types of parallelism available with DB2.
• Chapter 5, "About Data Warehousing", provides an overview of data warehousing and data warehousing tasks.
• Chapter 6, "About Spatial Extender", introduces Spatial Extender by explaining its purpose and discussing the data that it processes.

  Database Design

• Chapter 7, "Logical Database Design", discusses the concepts and guidelines for logical database design.
• Chapter 8, "Physical Database Design", discusses the guidelines for physical database design, including considerations related to data storage.
• Chapter 9, "Designing Distributed Databases", discusses how you can access multiple databases in a single transaction.
• Chapter 10, "Designing for Transaction Managers", discusses how you can use your databases in a distributed transaction processing environment, such as CICS.
• Chapter 11, "Designing for High Availability", presents an overview of the high availability failover support that is provided by DB2.

  Administering Using the Control Center

• Chapter 12, "Administering DB2 Using GUI Tools", introduces the Graphical User Interface (GUI) tools used to administer the database.

  Implementing Your Design

• Chapter 13, "Before Creating a Database", discusses the prerequisites before creating a database and the objects within a database.
• Chapter 14, "Creating a Database", discusses the tasks associated with creating a database and the objects within a database.
• Chapter 15, "Altering a Database", discusses the prerequisites and the tasks associated with altering or dropping a database and the objects within a database.

  Database Security

• Chapter 16, "Controlling Database Access", describes how you can control access to your database's resources.
• Chapter 17, "Auditing DB2 Activities", describes how you can detect and monitor unwanted or unanticipated access to data.

  Moving Data

• Chapter 18, "Utilities for Moving Data", discusses the Load, AutoLoader, Import and Export utilities.

  Recovery

• Chapter 19, "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.

  Introduction to Performance

• Chapter 20, "Elements of Performance", introduces concepts and considerations for managing and improving DB2 UDB performance.
• Chapter 21, "Architecture and Processes Overview", introduces underlying DB2 Universal Database architecture and processes.

  Tuning Application Performance

• Chapter 22, "Application Considerations", describes some techniques for improving database performance when designing your applications.
• Chapter 23, "Environmental Considerations", describes some techniques for improving database performance when setting up your database environment.
• Chapter 24, "System Catalog Statistics", describes how statistics about your data can be collected and used to ensure optimal performance.
• Chapter 25, "Understanding the SQL Compiler", describes what happens to an SQL statement when it is compiled using the SQL compiler.
• Chapter 26, "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 27, "Operational Performance", provides an overview of how the database manager uses memory and other considerations that affect run-time performance.
• Chapter 28, "Using the Governor", provides an introduction to the use of a governor to control some aspects of database management.
• Chapter 29, "Scaling Your Configuration Through Adding Processors", introduces some considerations and tasks associated with increasing the size of your database systems.
• Chapter 30, "Redistributing Data Across Database Partitions", discusses the tasks required in a partitioned database environment to redistribute data across partitions.
• Chapter 31, "Benchmark Testing", provides an overview of benchmark testing and how to perform benchmark testing.
• Chapter 32, "Configuring DB2", discusses the database manager and database configuration files and the values for the configuration parameters.

  High Availability Systems

• Chapter 33, "High Availability Cluster Multi-processing, Enhanced Scalability (HACMP ES) for AIX", discusses DB2 support for high availability failover recovery on AIX.
• Chapter 34, "High Availability in the Windows NT Environment", discusses DB2 support for high availability failover recovery on Windows NT.
• Chapter 35, "DB2 and High Availability on Sun Cluster 2.2", discusses DB2 support for high availability failover recovery on the Sun Solaris operating system.

  Appendixes

• Appendix A, "Naming Rules", presents the rules to follow when naming databases and objects.
• Appendix B, "Planning Database Migration", provides information about migrating databases to Version 7.
• Appendix C, "Incompatibilities Between Releases", presents the incompatibilities introduced from release to release up to, and including, Version 7.
• Appendix D, "DB2 Registry and Environment Variables", presents profile registry values and environment variables.
• Appendix E, "Using Distributed Computing Environment (DCE) Directory Services", provides information about how you can use DCE Directory Services.
• Appendix F, "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 G, "Explain Tables and Definitions", provides information about the tables used by the DB2 Explain facility and how to create those tables.
• Appendix H, "SQL Explain Tools", provides information on using the DB2 explain tools: db2expln and dynexpln.
• Appendix I, "db2exfmt - Explain Table Format Tool", formats the contents of the DB2 explain tables.
• Appendix J, "National Language Support (NLS)", introduces DB2 National Language Support, including information about countries, languages, and code pages.
• Appendix K, "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 L, "How DB2 for Windows NT Works with Windows NT Security", describes how DB2 works with Windows NT security.
• Appendix M, "Using the Windows NT Performance Monitor", describes the two performance monitors available to DB2 for Windows NT users: the DB2 Performance Monitor, and the Windows NT Performance Monitor.
• Appendix N, "Working with Windows NT or Windows 2000 Database Partition Servers", describes the utilities used by Windows NT and Windows 2000 to work with partitioned datababse servers.
• Appendix O, "Configuring Multiple Logical Nodes", describes how to configure multiple logical nodes in a partitioned database environment.
• Appendix P, "High Speed Inter-node Communications", describes how to enable Virtual Interface Architecture for use with DB2 Enterprise - Extended Edition in the Windows NT environment.
• Appendix Q, "Lightweight Directory Access Protocol (LDAP) Directory Services", provides information about how you can use LDAP Directory Services.
• Appendix R, "Extending the Control Center", provides information about how you can extend the Control Center by adding new tool bar buttons including new actions, adding new object definitions, and adding new action definitions.
• Appendix S, "Using the DB2 Library", provides information about the structure of the DB2 library, including wizards, online help, messages, and books.