DB2 for z/OS and OS/390 Development for Performance in two volumes (this is Volume 2 of 2) in its fourth edition has been rewritten to incorporate the many new features and facilities of the most recent Versions of DB2 through Version 7. Many guidelines for the design and development of application systems for performance have changed with changes to DB2. The book is organized to follow the life cycle of an application system, beginning with the creation of objects and the design of indexes to lay the foundation for high performing systems. Programmer/analyst must develop high performing SQL to process data efficiently and have the knowledge base to tune SQL when required to meet response time requirements with minimal I/O and CPU time usage to minimize costs. The book concludes with the use of utilities for efficient maintenance of the data.It provides indepth coverage of design and development of application systems for performance using DB2. Many examples of high performing SQL are given including actual timings to indicate the order of magnitude improvements that can be achieved by following the guidelines discussed. Alternatives are presented and discussed along with the pros and cons so that you can make the proper decisions for your application system. The author provides many practical examples, hints, tips, and guidelines for the design and development of application systems.This book is an excellent resource for professional database designers and developers. It is concise and easy to read -- making it an understandable guide for beginners as well.