Chapter 8, Operational performance", provides an overview of how the database manager uses memory and other considerations that affect run-time performance. Chapter 9, "Using the governor", provides an introduction to the use of a governor to control some aspects of database managemer Chapter 10, "Scaling your configuration", introduces some considerations and tasks associated with increasing the size of your database systems Chapter 11, "Redistributing Data Across Database Partitions", discusses the tasks required in a partitioned database environment to redistribute data across partitions Chapter 12, "Benchmark testing", provides an overview of benchmark testing and how to perform benchmark testing Chapter 13, " Configuring DB2", discusses the database manager and database config files and the values for the database manager, database and Da figuration parameters. Appendixes Appendix A, " DB2 Registry and Environment Variables", presents profile registry values and environment variables. Appendix B, "Explain tables", The explain table section provides information about the tables used by the dB2 Explain facility and how to create those tables Appendix C, "SQL explain tools", provides information on using the DB2 explain tools: db2expIn and dynexpln Appendix D, "db2exfmt- Explain table-format tool", formats the contents of the DB2 explain tables 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 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. About this book xi
v Chapter 8, “Operational performance”, provides an overview of how the database manager uses memory and other considerations that affect run-time performance. v Chapter 9, “Using the governor”, provides an introduction to the use of a governor to control some aspects of database management. v Chapter 10, “Scaling your configuration”, introduces some considerations and tasks associated with increasing the size of your database systems. v Chapter 11, “Redistributing Data Across Database Partitions”, discusses the tasks required in a partitioned database environment to redistribute data across partitions. v Chapter 12, “Benchmark testing”, provides an overview of benchmark testing and how to perform benchmark testing. v Chapter 13, “Configuring DB2”, discusses the database manager and database configuration files and the values for the database manager, database, and DAS configuration parameters. Appendixes v Appendix A, “DB2 Registry and Environment Variables”, presents profile registry values and environment variables. v Appendix B, “Explain tables”, The explain table section provides information about the tables used by the DB2 Explain facility and how to create those tables. v Appendix C, “SQL explain tools”, provides information on using the DB2 explain tools: db2expln and dynexpln. v Appendix D, “db2exfmt - Explain table-format tool”, formats the contents of the DB2 explain tables. 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. About this book xi
Database Design Logical 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. Appendixes 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: 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 database 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 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. appendixes Naming Rules"presents the rules to follow when naming databases and xii Administration Guide: performance
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: 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. xii Administration Guide: Performance
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 security 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 omparable 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 About this book xiii
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. 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. About this book xiii
Part 1. Introduction to performance right IBM Corp. 1993-2002
Part 1. Introduction to performance © Copyright IBM Corp. 1993 - 2002 1
Chapter 1 Introduction to performance The sections in this chapter describe performance tuning and provide some Creating a performance monitoring and tuning plan Using user information about performance problems Getting a quick start on initial performance tuning Elements of performance Performance is the way a computer system behaves given a particular work load Performance is measured in terms of system response time, throughput, and availability. Performance is also affected by The resources available in your system How well those resources are used and shared In general, you tune your system to improve its cost-benefit ratio. Specific goals could include Processing a larger, or more demanding, work load without increasing processing costs For example, to increase the work load without buying new hardware or using more processor time Obtaining faster system response times, or higher throughput, without ncreasing processing costs Reducing processing costs without degrading service to your users Translating performance from technical terms to economic terms is difficult. Performance tuning certainly costs money in terms of user time as well as processor time, so before you undertake a tuning project, weigh its costs against its possible benefits. Some of these benefits are tangible More efficient use of resources The ability to add more users to the system Other benefits, such as greater user satisfaction because of quicker response time, are intangible. All of these benefits should be considered Related concepts Performance-tuning guidelines"on page 4 Quick-start tips for performance tuning"on page 7 o Copyright IBM Corp. 1993-2002
Chapter 1. Introduction to performance The sections in this chapter describe performance tuning and provide some suggestions for: v Creating a performance monitoring and tuning plan v Using user information about performance problems v Getting a quick start on initial performance tuning Elements of performance Performance is the way a computer system behaves given a particular work load. Performance is measured in terms of system response time, throughput, and availability. Performance is also affected by: v The resources available in your system v How well those resources are used and shared. In general, you tune your system to improve its cost-benefit ratio. Specific goals could include: v Processing a larger, or more demanding, work load without increasing processing costs For example, to increase the work load without buying new hardware or using more processor time v Obtaining faster system response times, or higher throughput, without increasing processing costs v Reducing processing costs without degrading service to your users Translating performance from technical terms to economic terms is difficult. Performance tuning certainly costs money in terms of user time as well as processor time, so before you undertake a tuning project, weigh its costs against its possible benefits. Some of these benefits are tangible: v More efficient use of resources v The ability to add more users to the system. Other benefits, such as greater user satisfaction because of quicker response time, are intangible. All of these benefits should be considered. Related concepts: v “Performance-tuning guidelines” on page 4 v “Quick-start tips for performance tuning” on page 7 © Copyright IBM Corp. 1993 - 2002 3