IBM DB2 Universal database 重重 Administration Guide: Planning Version 8
IBM® DB2 Universal Database™ Administration Guide: Planning Version 8 SC09-4822-00
IBM DB2 Universal database 重重 Administration Guide: Planning Version 8
IBM® DB2 Universal Database™ Administration Guide: Planning Version 8 SC09-4822-00
efore using this information and the product it supports, be sure to read the general information under Notices This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. ToorderpublicationsonlinegototheIbMPublicationsCenteratwww.ibm.com/shop/publications/order To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-YOU (426-4968) When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incur ny obligation to you o Copyright International Business Machines Corporation 1993-2002. All rights reserved. US Government Users Restricted Rights- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp
Before using this information and the product it supports, be sure to read the general information under Notices. This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/order v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/planetwide To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU (426-4968). When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. © Copyright International Business Machines Corporation 1993 - 2002. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp
Contents About this book vii Chapter 4. Logical database design 47 Who should use this book What to record in a database How this book is structured Database relationships a brief overview of the other Administration One-to-many and many-to-one Guide volumes relationships Administration Guide: Implementation.. ix Many-to-many relationships Administration Guide: Performance One-to-one relationships Ensure that equal values represent the Part 1. Database concepts same entity Column definitions 900125 Chapter 1. Basic relational database Primary keys concepts Identifying candidate key columns Identity columns Configuration parameters Normalization 2556788 Business rules for data First normal form Second normal form Developing a Backup and Recovery Strategy 19 Third normal form Authentication Fourth normal form Authorization Multidimensional clustering Considerations when choosing MDC table dimensions Chapter 2 Parallel database systems Considerations when creating MDC tables Data partitioning Constraints Parallelism Unique constraints Input/output parallelism. Referential constraints Query parallelism Table check constraints 885 Partition and processor environments Triggers Single partition on a single processor Additional database design considerations Single partition with multiple processors 31 Chapter 5 Physical database design Multiple partition configuration ummary of parallelism best suited to each Database directories and files hardware environment Space requirements for database objec Space requirements for system catalog tables 882g9 Chapter 3. About data warehousing Space requirements for user table data What is data warehousing? Space requirements for long field data 39 space requirements for large object data Data warehouse objects 95%g Subject areas Space requirements for log files Warehouse sources Warehouse targets Space requirements for temporary tables 40 Database partition groups 102 Warehouse agents and agent sites Database partiti 104 Processes and steps Warehouse tasks Partitioning maps Partitioning keys Table collocation Part 2. Database design Partition compatibility o Copyright IBM Corp. 1993-2002
Contents About this book . . . . . . . . . . vii Who should use this book . . . . . . . viii How this book is structured . . . . . . viii A brief overview of the other Administration Guide volumes . . . . . . . . . . . ix Administration Guide: Implementation . . ix Administration Guide: Performance . . . x Part 1. Database concepts. . . . .1 Chapter 1. Basic relational database concepts . . . . . . . . . . . . .3 Database objects . . . . . . . . . . .3 Configuration parameters . . . . . . . 13 Business rules for data . . . . . . . . 15 Developing a Backup and Recovery Strategy 19 Security . . . . . . . . . . . . . 22 Authentication . . . . . . . . . . . 23 Authorization . . . . . . . . . . . 24 Chapter 2. Parallel database systems. . . 25 Data partitioning . . . . . . . . . . 25 Parallelism . . . . . . . . . . . . 26 Input/output parallelism. . . . . . . 26 Query parallelism . . . . . . . . . 26 Utility parallelism . . . . . . . . . 29 Partition and processor environments . . . 30 Single partition on a single processor . . 30 Single partition with multiple processors 31 Multiple partition configurations . . . . 33 Summary of parallelism best suited to each hardware environment . . . . . . . 37 Chapter 3. About data warehousing . . . 39 What is data warehousing? . . . . . . . 39 Data warehouse objects . . . . . . . . 39 Subject areas . . . . . . . . . . . 39 Warehouse sources . . . . . . . . . 40 Warehouse targets . . . . . . . . . 40 Warehouse agents and agent sites . . . . 40 Processes and steps . . . . . . . . 41 Warehouse tasks . . . . . . . . . . 43 Part 2. Database design . . . . . 45 Chapter 4. Logical database design . . . 47 What to record in a database . . . . . . 47 Database relationships . . . . . . . . 49 One-to-many and many-to-one relationships . . . . . . . . . . . 49 Many-to-many relationships. . . . . . 50 One-to-one relationships . . . . . . . 50 Ensure that equal values represent the same entity . . . . . . . . . . . 51 Column definitions . . . . . . . . . 52 Primary keys. . . . . . . . . . . . 54 Identifying candidate key columns . . . 55 Identity columns . . . . . . . . . . 56 Normalization . . . . . . . . . . . 57 First normal form . . . . . . . . . 58 Second normal form . . . . . . . . 58 Third normal form . . . . . . . . . 60 Fourth normal form . . . . . . . . 61 Multidimensional clustering. . . . . . . 62 Considerations when choosing MDC table dimensions . . . . . . . . . . . . 73 Considerations when creating MDC tables . . 77 Constraints . . . . . . . . . . . . 80 Unique constraints . . . . . . . . . 81 Referential constraints. . . . . . . . 81 Table check constraints . . . . . . . 84 Triggers . . . . . . . . . . . . . 85 Additional database design considerations . . 86 Chapter 5. Physical database design . . . 89 Database directories and files . . . . . . 89 Space requirements for database objects. . . 92 Space requirements for system catalog tables 93 Space requirements for user table data . . . 94 Space requirements for long field data . . . 95 Space requirements for large object data . . 96 Space requirements for indexes . . . . . 97 Space requirements for log files . . . . . 100 Space requirements for temporary tables . . 101 Database partition groups . . . . . . . 102 Database partition group design . . . . . 104 Partitioning maps . . . . . . . . . . 105 Partitioning keys . . . . . . . . . . 107 Table collocation . . . . . . . . . . 109 Partition compatibility . . . . . . . . 110 © Copyright IBM Corp. 1993 - 2002 iii
Replicated materialized query tables Transaction manager (TM) Table space design 112 Resource managers(rM) 7 System managed space 115 Resource manager setup 176 Database managed space 17 Database connection consideration Table space maps xa_open string formats 176 How containers are added and extended in xa_open string format for DB2 Version 7 DMS table spaces and later Rebalancing 124 xa_open string format for earlier versions 180 Without rebalancing(using stripe sets) 130 How containers are dropped and reduced in Updating host or iSeries database servers DMS table spaces 133 with an XA-compliant transaction manager 182 Comparison of SMS and DMS table spaces 136 Manually resolving indoubt transactions .. 182 Table disk I/O Security considerations for XA transaction Workload considerations in table space Configuration considerations for XA Extent size transaction managers Relationship between table spaces and buffer XA function supported by DB2 UDB 142 XA switch usage and location elationship between table spaces an Using the DB2 Universal Database XA abase partition groups switch Temporary table space design XA interface problem determination Catalog table space design XA transaction manager configuration Optimizing table space performance when Configuring IBM WebSphere Application data is on raid devices 147 Serve 191 Considerations when choosing table spaces Configuring IBM TXSeries CICS for your tables 149 Configuring IBM TXSeries Encina Configuring BEA Tuxedo Chapter 6. Designing Distributed Databases Part 3. Appendixes 197 Units of work Updating a single database in a transaction Using multiple databases in a single Appendix A Incompatibilities between releases transaction Updating a single database in a DB2 Universal Database planned multi-database transaction incompatibilities plating multiple databases in a System catalog information Utilities and tools DB2 transaction manager configuratio.. 158 Version 8 incompatibilities between releases 201 transaction DB2 transaction manager System Catalog Information 201 Updating a database from a host or iSeries Application programming Database security and tuning Utilities and tools Error recovery during two-phase commit 168 Error recovery if autorestart=off Connectivity and coexistence 214 tion parameters Chapter 7. Designing for XA-compliant transaction managers Version 7 incompatibilities between releases 219 171 X/Open distributed transaction processing Application Programming model Utilities and Tools Application program(AP) Connectivity and Coexistence IV Administration Guide: Planning
Replicated materialized query tables . . . 111 Table space design . . . . . . . . . 112 System managed space . . . . . . . . 115 Database managed space . . . . . . . 117 Table space maps . . . . . . . . . . 119 How containers are added and extended in DMS table spaces . . . . . . . . . . 123 Rebalancing. . . . . . . . . . . 124 Without rebalancing (using stripe sets) 130 How containers are dropped and reduced in DMS table spaces . . . . . . . . . . 133 Comparison of SMS and DMS table spaces 136 Table space disk I/O . . . . . . . . . 137 Workload considerations in table space design . . . . . . . . . . . . . 139 Extent size . . . . . . . . . . . . 141 Relationship between table spaces and buffer pools . . . . . . . . . . . . . . 142 Relationship between table spaces and database partition groups . . . . . . . 143 Temporary table space design. . . . . . 144 Catalog table space design . . . . . . . 146 Optimizing table space performance when data is on RAID devices . . . . . . . 147 Considerations when choosing table spaces for your tables . . . . . . . . . . . 149 Chapter 6. Designing Distributed Databases . . . . . . . . . . . . 153 Units of work . . . . . . . . . . . 153 Updating a single database in a transaction 154 Using multiple databases in a single transaction . . . . . . . . . . . . 155 Updating a single database in a multi-database transaction . . . . . . 155 Updating multiple databases in a transaction . . . . . . . . . . . 156 DB2 transaction manager . . . . . . 158 DB2 transaction manager configuration 159 Updating a database from a host or iSeries client . . . . . . . . . . . . . . 163 Two-phase commit . . . . . . . . . 165 Error recovery during two-phase commit 168 Error recovery if autorestart=off . . . . 169 Chapter 7. Designing for XA-compliant transaction managers . . . . . . . . 171 X/Open distributed transaction processing model. . . . . . . . . . . . . . 172 Application program (AP) . . . . . . 172 Transaction manager (TM) . . . . . . 174 Resource managers (RM) . . . . . . 175 Resource manager setup . . . . . . . 176 Database connection considerations . . . 176 xa_open string formats . . . . . . . . 176 xa_open string format for DB2 Version 7 and later . . . . . . . . . . . . 176 xa_open string format for earlier versions 180 Examples . . . . . . . . . . . 180 Updating host or iSeries database servers with an XA-compliant transaction manager . 182 Manually resolving indoubt transactions . . 182 Security considerations for XA transaction managers . . . . . . . . . . . . 185 Configuration considerations for XA transaction managers . . . . . . . . 186 XA function supported by DB2 UDB . . . 188 XA switch usage and location. . . . . 188 Using the DB2 Universal Database XA switch . . . . . . . . . . . . 189 XA interface problem determination . . . 190 XA transaction manager configuration . . . 191 Configuring IBM WebSphere Application Server. . . . . . . . . . . . . 191 Configuring IBM TXSeries CICS . . . . 191 Configuring IBM TXSeries Encina . . . 191 Configuring BEA Tuxedo . . . . . . 193 Part 3. Appendixes . . . . . . . 197 Appendix A. Incompatibilities between releases . . . . . . . . . . . . 199 DB2 Universal Database planned incompatibilities . . . . . . . . . . 200 System catalog information . . . . . 200 Utilities and tools . . . . . . . . . 200 Version 8 incompatibilities between releases 201 System Catalog Information . . . . . 201 Application programming . . . . . . 202 SQL . . . . . . . . . . . . . 207 Database security and tuning . . . . . 212 Utilities and tools . . . . . . . . . 213 Connectivity and coexistence . . . . . 214 Messages . . . . . . . . . . . 217 Configuration parameters . . . . . . 218 Version 7 incompatibilities between releases 219 Application Programming . . . . . . 219 SQL . . . . . . . . . . . . . 221 Utilities and Tools. . . . . . . . . 223 Connectivity and Coexistence . . . . . 223 iv Administration Guide: Planning
Appendix B. National language support Ordering printed DB2 books Accessing online help 28 National language versions 225 Finding topics by accessing he DB2 Supported territory codes and code pages 225 Information Center from a browser Enabling and disabling euro symbol support 245 Finding product information by accessing Conversion table files for euro-enabled code the DB2 Information Center from the administration tools Conversion tables for code pages 923 and Viewing technical documentation online 924. 256 directly from the DB2 HTML Documentation Choosing a language for your database 294 Locale setting for the DB2 Administration Updating the HTML documentation installed on your machine Enabling bidirectional support 258 Copying files from the DB2 HTML Bidirectional-specific CCSIDs 259 Documentation CD to a Web server Bidirectional support ith dB2 Connect Troubleshooting DB2 documentation search Collating Thai characters 66 Searching the DB2 documentation Date and time formats by territory code 66 Online DB2 troubleshooting information Unicode character encoding 269 Accessibility Keyboard Input and Navigation UTF-8 Accessible Display UTF-16 Alternative Alert Cues Unicode implementation in DB Compatibility with Assistive Technologies 300 Code Page/CCSID Numbers Accessible documentation Unicode handling of data types DB2 tutorials Creating a Unicode database DB2 Information Center accessed from a Unicode literals 276br owser String comparisons in a Unicode database Appendix D. Notices 303 ppendix c DB2 Universal Database Trademarks technical information Overview of DB2 Universal Database Inde 309 technical information FixPaks for db2 documentation Co Ing IBM 315 Printing DB2 books from PDF files nation Categories of DB2 technical infor Product informatio
Appendix B. National language support (NLS) . . . . . . . . . . . . . 225 National language versions . . . . . . 225 Supported territory codes and code pages 225 Enabling and disabling euro symbol support 245 Conversion table files for euro-enabled code pages . . . . . . . . . . . . . . 246 Conversion tables for code pages 923 and 924. . . . . . . . . . . . . . . 256 Choosing a language for your database . . 257 Locale setting for the DB2 Administration Server. . . . . . . . . . . . . 257 Enabling bidirectional support . . . . . 258 Bidirectional-specific CCSIDs . . . . . . 259 Bidirectional support with DB2 Connect . . 262 Collating Sequences . . . . . . . . . 264 Collating Thai characters . . . . . . . 266 Date and time formats by territory code . . 266 Unicode character encoding . . . . . . 269 UCS-2. . . . . . . . . . . . . 270 UTF-8. . . . . . . . . . . . . 270 UTF-16 . . . . . . . . . . . . 270 Unicode implementation in DB2 . . . . . 271 Code Page/CCSID Numbers . . . . . 273 Unicode handling of data types . . . . . 274 Creating a Unicode database . . . . . . 275 Unicode literals . . . . . . . . . . 276 String comparisons in a Unicode database 276 Appendix C. DB2 Universal Database technical information . . . . . . . . 279 Overview of DB2 Universal Database technical information . . . . . . . . 279 FixPaks for DB2 documentation . . . . 279 Categories of DB2 technical information 279 Printing DB2 books from PDF files . . . . 287 Ordering printed DB2 books . . . . . . 288 Accessing online help . . . . . . . . 288 Finding topics by accessing the DB2 Information Center from a browser . . . . 290 Finding product information by accessing the DB2 Information Center from the administration tools . . . . . . . . . 292 Viewing technical documentation online directly from the DB2 HTML Documentation CD. . . . . . . . . . . . . . . 294 Updating the HTML documentation installed on your machine . . . . . . . . . . 294 Copying files from the DB2 HTML Documentation CD to a Web server. . . . 296 Troubleshooting DB2 documentation search with Netscape 4.x . . . . . . . . . . 297 Searching the DB2 documentation . . . . 298 Online DB2 troubleshooting information . . 299 Accessibility . . . . . . . . . . . 299 Keyboard Input and Navigation . . . . 300 Accessible Display . . . . . . . . 300 Alternative Alert Cues . . . . . . . 300 Compatibility with Assistive Technologies 300 Accessible Documentation . . . . . . 300 DB2 tutorials . . . . . . . . . . . 301 DB2 Information Center accessed from a browser . . . . . . . . . . . . . 302 Appendix D. Notices . . . . . . . . 303 Trademarks . . . . . . . . . . . . 306 Index . . . . . . . . . . . . . 309 Contacting IBM . . . . . . . . . . 315 Product information . . . . . . . . . 315 Contents v
About this book The Administration Guide in its three volumes provides information necessary (RDBMS) Products, and includes Information about database design(found in Administration Guide: Planning) Information about implementing and managing databases(found in Administration Guide: Implementation Information about configuring and tuning your database environment to improve performance(found in Administration Guide: Performance) Many of the tasks described in this book can be performed using different interfaces: The Command Line Processor, which allows you to access and manipul databases from a graphical interface. From this interface, you can also execute SQL statements and DB2 utility functions. Most examples in this book illustrate the use of this interface. For more information about using the command line processor, see the Command reference. The application programming interface, which allows you to execute DB2 utility functions within an application program. For more information about using the application programming interface, see the Administrative API Refe The Control Center, which allows you to use a graphical user interface to perform administrative tasks such as configuring the system, managing directories, backing up and recovering the system, scheduling jobs, and managing media. The Control Center also contains Replication Administration, which allows you set up the replication of data between systems. Further, the Control Center allows you to execute DB2 utility functions through a graphical user interface. There are different methods to invoke the Control Center depending on your platform. For example,use the db2cc command on a command line, select the Control Center icon from the DB2 folder, or use the Start menu on Windows platforms. For introductory help, select Getting started from the Help pull-down of the Control Center window. The Visual Explain and Performance Monitor tools are invoked from the Control Center There are other tools that you can use to perform administration tasks. they The Script Center to store small applications called scripts. These scripts may contain SQL statements, DB2 commands, as well as operating system commands right IBM Corp. 1993-2002
About this book The Administration Guide in its three volumes provides information necessary to use and administer the DB2 relational database management system (RDBMS) products, and includes: v Information about database design (found in Administration Guide: Planning) v Information about implementing and managing databases (found in Administration Guide: Implementation) v Information about configuring and tuning your database environment to improve performance (found in Administration Guide: Performance) Many of the tasks described in this book can be performed using different interfaces: v The Command Line Processor, which allows you to access and manipulate databases from a graphical interface. From this interface, you can also execute SQL statements and DB2 utility functions. Most examples in this book illustrate the use of this interface. For more information about using the command line processor, see the Command Reference. v The application programming interface, which allows you to execute DB2 utility functions within an application program. For more information about using the application programming interface, see the Administrative API Reference. v The Control Center, which allows you to use a graphical user interface to perform administrative tasks such as configuring the system, managing directories, backing up and recovering the system, scheduling jobs, and managing media. The Control Center also contains Replication Administration, which allows you set up the replication of data between systems. Further, the Control Center allows you to execute DB2 utility functions through a graphical user interface. There are different methods to invoke the Control Center depending on your platform. For example, use the db2cc command on a command line, select the Control Center icon from the DB2 folder, or use the Start menu on Windows platforms. For introductory help, select Getting started from the Help pull-down of the Control Center window. The Visual Explain and Performance Monitor tools are invoked from the Control Center. There are other tools that you can use to perform administration tasks. They include: v The Script Center to store small applications called scripts. These scripts may contain SQL statements, DB2 commands, as well as operating system commands. © Copyright IBM Corp. 1993 - 2002 vii
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: Plann
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: 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
Appendix A, " Incompatibilities between releases", presents the incompatibilities introduced by Version 7 and Version 8, as well as future incompatibilities that you should be aware of Appendix B, "National language support(NLS)", introduces DB2 National Language Support, including information about territories, languages, and code pages a brief overview of the other administration guide volumes Administration Guide: Implementation The Administration Guide: Implementation is concerned with the implementation of your database design. The specific chapters and appendixes in that volume are briefly described here Implementing Your Design Before Creating a Database"describes the prerequisites before you create a atabase Creating a Database"describes those tasks associated with the creation of a database and related database objects Altering a Database"discusses what must be done before altering a database and those tasks associated with the modifying or dropping of a database or related database objects. Database Security Controlling Database Access"describes how you can control access to your database's resources Auditing DB2 Activities" describes how you can detect and monitor unwanted or unanticipated access to data Appendix Naming Rules" presents the rules to follow when naming databases and Lightweight Directory Access Protocol(LDAP)Directory Services provides information about how you can use LDAP Directory Services Issuing Commands to Multiple Database Partition"discusses the use of the db2__all and rah shell scripts to send commands to all partitions in a partitioned database environment Windows Management Instrumentation(WMI) Support"describes how DB2 supports this management infrastructure standard to integrate various hardware and software management systems. Also discussed is how DB2 integrates with WMI How DB2 for Windows NT Works with Windows NT Security"describes how db2 works with Windows Nt securit IX
v Appendix A, “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 Appendix B, “National language support (NLS)”, introduces DB2 National Language Support, including information about territories, languages, and code pages. A brief overview of the other Administration Guide volumes Administration Guide: Implementation The Administration Guide: Implementation is concerned with the implementation of your database design. The specific chapters and appendixes in that volume are briefly described here: Implementing Your Design v ″Before Creating a Database″ describes the prerequisites before you create a database. v ″Creating a Database″ describes those tasks associated with the creation of a database and related database objects. v ″Altering a Database″ discusses what must be done before altering a database and those tasks associated with the modifying or dropping of a database or related database objects. Database Security v ″Controlling Database Access″ describes how you can control access to your database’s resources. v ″Auditing DB2 Activities″ describes how you can detect and monitor unwanted or unanticipated access to data. Appendixes v ″Naming Rules″ presents the rules to follow when naming databases and objects. v ″Lightweight Directory Access Protocol (LDAP) Directory Services″ provides information about how you can use LDAP Directory Services. v ″Issuing Commands to Multiple Database Partition″ discusses the use of the db2_all and rah shell scripts to send commands to all partitions in a partitioned database environment. v ″Windows Management Instrumentation (WMI) Support″ describes how DB2 supports this management infrastructure standard to integrate various hardware and software management systems. Also discussed is how DB2 integrates with WMI. v ″How DB2 for Windows NT Works with Windows NT Security″ describes how DB2 works with Windows NT security. About this book ix
Using the Windows Performance Monitor"provides information about registering DB2 with the Windows NT Performance Monitor, and using the performance information "Working with Windows Database Partition Servers"provides information about the utilities available to work with database partition servers on Windows nt or windows 2000 Configuring Multiple Logical Nodes"describes how to configure multiple logical nodes in a partitioned database environment. 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 Note: Two chapters have been removed from this book 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 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 All of the information on the methods and tools for backing up and recovering data, and the comparable topics from the Command Referenc 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. 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 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 x Administration Guide Planning
v ″Using the Windows Performance Monitor″ provides information about registering DB2 with the Windows NT Performance Monitor, and using the performance information. v ″Working with Windows Database Partition Servers″ provides information about the utilities available to work with database partition servers on Windows NT or Windows 2000. v ″Configuring Multiple Logical Nodes″ describes how to configure multiple logical nodes in a partitioned database environment. v ″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. Note: Two chapters have been removed from this book. 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. 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. 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 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. x Administration Guide: Planning