DB2 for z/OS and OS/390 Version 7 Performance Topics (IBM Redbooks)

"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."