The Alert Center to monitor the messages that result from other DB2 operations The Health Center provides a tool to assist DBAs in the resolution of performance and resource allocation problems The Tools Settings to change the settings for the Control Center, Alert Center, and Replication. The Journal to schedule jobs that are to run unattended. The Data Warehouse Center to manage warehouse objects Who should use this book This book is intended primarily for database administrators, system administrators, security administrators and system operators who need to design, implement and maintain a database to be accessed by local or remote lients. It can also be used by programmers and other users who require an understanding of the administration and operation of the DB2 relational database management system How this book is structured This book contains information about the following major topics Database Concepts Chapter 1, Basic relational database concepts", presents an overview of database objects and database concepts Chapter 2, "Parallel database systems", provides an introduction to the types of parallelism available with DB2 Chapter 3, "About data warehousing", provides an overview of data tasks Database Design Chapter 4, " Logical database design", discusses the concepts and guidelines for logical database design Chapter 5, Physical database design", discusses the guidelines for physical database design, including space requirements and table space design. Chapter 6, Designing Distributed Databa discusses how you can access multiple trar Chapter 7,"Designing for XA-compliant transaction managers", discusses how you can use your databases in a distributed transaction processing ministration Guide: Plannv The Alert Center to monitor the messages that result from other DB2 operations. v The Health Center provides a tool to assist DBAs in the resolution of performance and resource allocation problems. v The Tools Settings to change the settings for the Control Center, Alert Center, and Replication. v The Journal to schedule jobs that are to run unattended. v The Data Warehouse Center to manage warehouse objects. Who should use this book This book is intended primarily for database administrators, system administrators, security administrators and system operators who need to design, implement and maintain a database to be accessed by local or remote clients. It can also be used by programmers and other users who require an understanding of the administration and operation of the DB2 relational database management system. How this book is structured This book contains information about the following major topics: Database Concepts v Chapter 1, “Basic relational database concepts”, presents an overview of database objects and database concepts. v Chapter 2, “Parallel database systems”, provides an introduction to the types of parallelism available with DB2. v Chapter 3, “About data warehousing”, provides an overview of data warehousing and data warehousing tasks. Database Design v Chapter 4, “Logical database design”, discusses the concepts and guidelines for logical database design. v Chapter 5, “Physical database design”, discusses the guidelines for physical database design, including space requirements and table space design. v Chapter 6, “Designing Distributed Databases”, discusses how you can access multiple databases in a single transaction. v Chapter 7, “Designing for XA-compliant transaction managers”, discusses how you can use your databases in a distributed transaction processing environment. Appendixes viii Administration Guide: Planning