DB2 for z/OS and OS/390 Version 7 Performance Topics

IBM DATABASE 2 Universal Database Server for z/OS and OS/390 Version 7 (DB2 Universal Database Server for z/OS and OS/390 Version 7, or just DB2 V7 throughout this book) is the eleventh release of DB2 for MVS. It brings to this platform many new data support, application development, and SQL language enhancements for e-business while building upon the traditional capabilities of availability, scalability, and performance.

This IBM Redbook describes the performance implications of several enhancements made available with DB2 V7. These enhancements include performance and availability delivered through new and enhanced utilities, dynamic changes to the value of many of the system parameters without stopping DB2, and the new Restart Light option for data sharing environments. There are many improvements to usability, such as scrollable cursors, support for UNICODE encoded data, support for COMMIT and ROLLBACK within a stored procedure, the option to eliminate the DB2 precompile step in program preparation, and the definition of view with the operators UNION or UNION ALL.

This book will help you understand why migrating to Version 7 of DB2 can be beneficial for your applications and your DB2 subsystems. It provides considerations and recommendations for the implementation of the new functions and for evaluating their performance and their applicability to your DB2 environments.

Chapter 1. Introduction
Chapter 2. Overview of DB2 Version 7
Chapter 3. SQL performance
Chapter 4. DB2 subsystem performance
Chapter 5. Availability and capacity enhancements
Chapter 6. Utility performance
Chapter 7. Network computing performance
Chapter 8. Data sharing
Chapter 9. Performance tools
Chapter 10. Synergy with host platform
Appendix A. Updatable DB2 subsystem parameters
Appendix B. Enabling VSAM I/O striping in OS/390 V2R10
Appendix C. A method to assess the size of the buffer pools
Appendix D. Sample PL/1 program
Appendix E. Sample utilities output

• Rational Application Developer V7 Programming Guide, SG24-7501-00
• MQSeries Primer, REDP-0021-00
• IBM eServer Certification Study Guide - pSeries AIX System Administration, SG24-6191-00

Publish Date
03 July 2001

Last Update
27 June 2003

Rating:
(based on 5 reviews)

Rate this book

Author(s)

Paolo Bruni is on assignment as a Data Management Specialist for DB2 for OS/390 at the International Technical Support Organization, San Jose Center, where he conducts projects on all areas of DB2 for OS/390. Before joining the ITSO in 1998, Paolo worked as a Consultant IT Architect in IBM Italy. During his 31 years with IBM, in development and in the field, Paolo's work has been mostly related to database systems.

• Paolo Bruni

ISBN

0738419672

IBM Form Number
SG24-6129-00

Number of pages
262