Search -
DB2 for OS/390 and z/OS Development for Performance
DB2 for OS/390 and z/OS Development for Performance Author:Gabrielle Wiorkowski DB2 for OS/390 and z/OS Development for Performance in its third edition is the first book to include the features and facilities of V7 integrated into the book. It is the oldest and newest book on DB2. It is the oldest in that the original material was developed during ESP of V1.1 in 1983 and rewritten in each of the author’s previous five... more » books. It is the newest in that it is constantly updated for each release/version (plus current PTFs and APARs), has incorporated the input of over 15,000 course attendees in 27 countries on 6 continents, and has grown with DB2 to 1,412 pages. This edition even has V7, V6, or V5 APAR number noted with the first occurrence of a feature specific to the version or APAR. In addition, the index has an entry for each item as generated by a word processor so you can easily find features of V7, V6, and V5 APARs. 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 the new utilities for efficient maintenance of the data. It provides indepth coverage of the 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 experienced DB2 professionals as well as providing a concise and easy-to-read guide for those new to DB2.« less