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 Implementing Your Design before creating a database and the objects within a database quisites needed Chapter 1, Before Creating a Database", describes the prere Chapter 2, Creating a Database", describes the tasks associated with creating a database and the objects within a database Chapter 3, " Altering a Database", describes the prerequisites and the tasks associated with altering or dropping a database and the objects within a database Database Security Chapter 4, Controlling Database Access", describes how you can control access to your databases resources Chapter 5, "Auditing DB2 Activities", describes how you can detect and monitor unwanted or unanticipated access to data Appendixes Appendix A, "Naming Rules", presents the rules to follow when naming databases and objects Appendix B, " Lightweight Directory Access Protocol (LDAP)Directory Services provides information about how you can use LDAP Directory X Administration Guide: Implementation
v 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: Implementing Your Design v Chapter 1, “Before Creating a Database”, describes the prerequisites needed before creating a database and the objects within a database. v Chapter 2, “Creating a Database”, describes the tasks associated with creating a database and the objects within a database. v Chapter 3, “Altering a Database”, describes the prerequisites and the tasks associated with altering or dropping a database and the objects within a database. Database Security v Chapter 4, “Controlling Database Access”, describes how you can control access to your database’s resources. v Chapter 5, “Auditing DB2 Activities”, describes how you can detect and monitor unwanted or unanticipated access to data. Appendixes v Appendix A, “Naming Rules”, presents the rules to follow when naming databases and objects. v Appendix B, “Lightweight Directory Access Protocol (LDAP) Directory Services”, provides information about how you can use LDAP Directory Services. x Administration Guide: Implementation
Appendix C, "Issuing Commands to Multiple Database Partitions discusses the use of the db2 _all and rah shell scripts to send commands to Appendix D, Windows Management Instrumentation(WMI) Support provides information about how DB2 can be managed using WMI Appendix E, "How DB2 for Windows NT Works with Windows NT Security", describes how DB2 works with Windows security Appendix F, Using the Windows Performance Monitor", describes how to use the Windows Performance Monitor to collect DB2 performance data Appendix G, Working with Windows Database Partition Servers describes the utilities used by Windows to work with partitioned database servers. Appendix H, " Configuring Multiple Logical Nodes", describes how to configure multiple logical nodes in a partitioned database environment Appendix I, "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 A chapter was moved from the Administration Guide: Implementation manual that had the title"Utilities for Moving Data Note: All of the information on the DB2 utilities for moving data, and the comparable topics from the Command Reference and the Administrative API Reference, have been consolidated into the Data Movement utilities Guide and reference The Data Movement utilities Guide and Reference is your primary, single source of information for these topics To find out more about replication of data, see Replication Guide and Reference A chapter was moved from the Administration Guide: Implementation manual that had the title "Recovering a database" Note: All of the information on the methods and tools for backing up and recovering data, and the comparable topics from the Command Reference and the Administrative API Reference, have been consolidated into the Data Recovery and High Availability Guide and reference. primary, single source of information for these topics ce is your The Data Recovery and High Availability Guide and Referer
v Appendix C, “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. v Appendix D, “Windows Management Instrumentation (WMI) Support”, provides information about how DB2 can be managed using WMI. v Appendix E, “How DB2 for Windows NT Works with Windows NT Security”, describes how DB2 works with Windows security. v Appendix F, “Using the Windows Performance Monitor”, describes how to use the Windows Performance Monitor to collect DB2 performance data. v Appendix G, “Working with Windows Database Partition Servers”, describes the utilities used by Windows to work with partitioned database servers. v Appendix H, “Configuring Multiple Logical Nodes”, describes how to configure multiple logical nodes in a partitioned database environment. v Appendix I, “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. A chapter was moved from the Administration Guide: Implementation manual that had the title “Utilities for Moving Data”. Note: All of the information on the DB2 utilities for moving data, and the comparable topics from the Command Reference and the Administrative API Reference, have been consolidated into the Data Movement Utilities Guide and Reference. The Data Movement Utilities Guide and Reference is your primary, single source of information for these topics. To find out more about replication of data, see Replication Guide and Reference. A chapter was moved from the Administration Guide: Implementation manual that had the title “Recovering a Database”. Note: All of the information on the methods and tools for backing up and recovering data, and the comparable topics from the Command Reference and the Administrative API Reference, have been consolidated into the Data Recovery and High Availability Guide and Reference. The Data Recovery and High Availability Guide and Reference is your primary, single source of information for these topics. About this book xi
a brief overview of the other administration guide volumes Administration Guide: Planning The Administration Guide: Planning is concerned with database design. It presents logical and physical design issues and distributed transaction issues The specific chapters and appendixes in that volume are briefly described Database Concepts Basic Relational Database Concepts"presents an overview of database objects, including recovery objects, storage objects, and system objects Parallel Database Systems" provides an introduction to the types of parallelism available with DB2 About Data Warehousing"provides an overview of data warehousing and data warehousing tasks Database design Database Design"discusses the concepts and guidelines for logical database design. Physical Database Design"discusses the guidelines for physical database design, including considerations related to data storage Distributed Transaction Processing Designing Distributed Databases"discusses how you can access multiple databases in a single transaction "Designing for Transaction Managers"discusses how you can use your databases in a distributed transaction processing environment. Ap Incompatibilities Between Releases"presents the incompatibilities introduced by Version 7 and Version 8, as well as future incompatibilities that you should be aware of "National Language Support(NLS)"describes DB2 National Language Support, including information about territories, languages, and code pages Administration Guide: Performance The Administration Guide: Performance is concerned with performance issues that is, those topics and issues concerned with establishing, testing, and improving the performance of your application, and that of the DB2 Universal Database product itself. The specific chapters and appendixes in that volume are briefly described here Introduction to performanc Xll Administration Guide: Implementatio
A brief overview of the other Administration Guide volumes Administration Guide: Planning The Administration Guide: Planning is concerned with database design. It presents logical and physical design issues and distributed transaction issues. The specific chapters and appendixes in that volume are briefly described here: Database Concepts v ″Basic Relational Database Concepts″ presents an overview of database objects, including recovery objects, storage objects, and system objects. v ″Parallel Database Systems″ provides an introduction to the types of parallelism available with DB2. v ″About Data Warehousing″ provides an overview of data warehousing and data warehousing tasks. Database Design v ″Logical Database Design″ discusses the concepts and guidelines for logical database design. v ″Physical Database Design″ discusses the guidelines for physical database design, including considerations related to data storage. Distributed Transaction Processing v ″Designing Distributed Databases″ discusses how you can access multiple databases in a single transaction. v ″Designing for Transaction Managers″ discusses how you can use your databases in a distributed transaction processing environment. Appendixes v ″Incompatibilities Between Releases″ presents the incompatibilities introduced by Version 7 and Version 8, as well as future incompatibilities that you should be aware of. v ″National Language Support (NLS)″ describes DB2 National Language Support, including information about territories, languages, and code pages. Administration Guide: Performance The Administration Guide: Performance is concerned with performance issues; that is, those topics and issues concerned with establishing, testing, and improving the performance of your application, and that of the DB2 Universal Database product itself. The specific chapters and appendixes in that volume are briefly described here: Introduction to Performance xii Administration Guide: Implementation
Introduction to Performance" introduces concepts and considerations for managing and improving DB2 UDB performance Architecture and Processes"introduces underlying DB2 Universal Database architecture and processes Tuning Application Performance pplication Considerations" describes some techniques for improving database performance when designing your applications Environmental Considerations" describes some techniques for improving database performance when setting up your database environment System Catalog Statistics"describes how statistics about your data can be collected and used to ensure optimal performance. Understanding the SQL Compiler"describes what happens to an SQL statement when it is compiled using the SQL compiler. 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 Operational Performance"describes an overview of how the database manager uses memory and other considerations that affect run-time performance Using the Governor" describes an introduction to the use of a governor to control some aspects of database management aling Your Configuration" describes some considerations and task associated with increasing the size of your database systems Redistributing Data Across Database Partitions" discusses the tasks rtitioned database environment to redistribute data across partitions. Benchmark Testing"presents an overview of benchmark testing and how to perform benchmark testing Configuring DB2" discusses the database manager and database configuration files and the values for the database manager, database, and DAS configuration parameters Appendixes DB2 Registry and Environment Variables"describes profile registry values and environment variables Explain Tables and Definitions"describes the tables used by the DB2 Explain facility and how to create those tables SQL Explain Tools"describes how to use the DB2 explain tools: db2expln and dynexpln about this book xIll
v ″Introduction to Performance″ introduces concepts and considerations for managing and improving DB2 UDB performance. v ″Architecture and Processes″ introduces underlying DB2 Universal Database architecture and processes. Tuning Application Performance v ″Application Considerations″ describes some techniques for improving database performance when designing your applications. v ″Environmental Considerations″ describes some techniques for improving database performance when setting up your database environment. v ″System Catalog Statistics″ describes how statistics about your data can be collected and used to ensure optimal performance. v ″Understanding the SQL Compiler″ describes what happens to an SQL statement when it is compiled using the SQL compiler. v ″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 v ″Operational Performance″ describes an overview of how the database manager uses memory and other considerations that affect run-time performance. v ″Using the Governor″ describes an introduction to the use of a governor to control some aspects of database management. v ″Scaling Your Configuration″ describes some considerations and tasks associated with increasing the size of your database systems. v ″Redistributing Data Across Database Partitions″ discusses the tasks required in a partitioned database environment to redistribute data across partitions. v ″Benchmark Testing″ presents an overview of benchmark testing and how to perform benchmark testing. v ″Configuring DB2″ discusses the database manager and database configuration files and the values for the database manager, database, and DAS configuration parameters. Appendixes v ″DB2 Registry and Environment Variables″ describes profile registry values and environment variables. v ″Explain Tables and Definitions″ describes the tables used by the DB2 Explain facility and how to create those tables. v ″SQL Explain Tools″ describes how to use the DB2 explain tools: db2expln and dynexpln. About this book xiii
db2exfmt -Explain Table Format Tool"describes how to use the DB2 explain tool to format the explain table data xXIv Administration Guide: Implementation
v ″db2exfmt — Explain Table Format Tool″ describes how to use the DB2 explain tool to format the explain table data. xiv Administration Guide: Implementation