Skip to main content

   

IBM Redbooks  >  Infrastructure Solutions




Redbooks Abstract

DB2 UDB for z/OS Version 8 Performance Topics



Download PDF (6.6 MB)


Get AdobeĀ® ReaderĀ®


View as HTML


Tips for viewing


Order Hardcopy


Others who downloaded this book also downloaded ...

Abstract

IBM DATABASE 2 Universal Database Server for z/OS Version 8 (DB2 V8 throughout this IBM Redbook) is the twelfth and largest release of DB2 for MVS. It brings synergy with the zSeries hardware and exploits the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional characteristics of availability, exceptional scalability, and performance for the enterprise of choice.
Key improvements enhance scalability, application porting, security architecture, and continuous availability. Management for very large databases is made much easier, while 64-bit virtual storage support makes management simpler and improves scalability and availability. This new version breaks through many old limitations in the definition of DB2 objects, including SQL improvements, schema evolution, longer names for tables and columns, longer SQL statements, enhanced Java and Unicode support, enhanced utilities, and more log data sets.
This redbook introduces the major performance and availability changes as well as the performance characteristics of many new functions. It helps you understand the performance implications of migrating to DB2 V8 with considerations based on laboratory measurements. It provides the type of information needed to start evaluating the performance impact of DB2 V8 and its capacity planning needs.

Table of Contents

Chapter 1. DB2 UDB for z/OS Version 8
Chapter 2. Performance overview
Chapter 3. SQL performance
Chapter 4. DB2 subsystem performance
Chapter 5. Availability and capacity enhancements
Chapter 6. Utilities
Chapter 7. Networking and e-business
Chapter 8. Data sharing enhancements
Chapter 9. Installation and migration
Chapter 10. Performance tools
Appendix A. Summary of performance maintenance
Appendix B. The DBM1 storage map
Appendix C. SQL PA sample reports
Appendix D. EXPLAIN and its tables

Others who downloaded this publication also downloaded
DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More, SG24-6079-00
Rational Application Developer V7 Programming Guide, SG24-7501-00
DB2 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7083-00


Profile

Publish Date
11 April 2005

Last Update
01 October 2007

Rating: rating
(based on 6 reviews)

Rate this book

Author(s)
Paolo Bruni
Doracilio Fernandes de Farias Jr
Yoshio Ishii
Michael Parbs
Mary Petras
Tsumugi Taira
Jan Vandensande

ISBN
0738492493

IBM Form Number
SG24-6465-00

Number of pages
456