Softcover

ISBN 10: 0966846001 ISBN 13: 9780966846003

Publisher: Gabrielle & Associates, 1998

The DB2 for OS/390 Development for Performance book (985 pages) provides a practical, indepth guide to application design, development, and tuning with emphasis on ensuring good performance in a production environment. The book teaches proven techniques for tuning and developing application systems. It gives numerous hints, tips and guidelines on developing application systems to achieve high performance based upon the experience of the author and the input of over 14,000 DB2 professionals. These professionals from most major companies in 27 countries have attended the seminars upon which the book is based and contributed to the material since 1984.

An understanding of DB2 processing is required and conveyed so that you can apply the guidelines to your specific applications. Companies use DB2 in a variety of ways depending on their business requirements, the type of application systems to be designed and developed, tuning of existing applications, and on the organizational structure of the company. Therefore, a number of alternatives for dealing with issues are presented and analyzed in terms of their advantages and disadvantages. This allows you to choose the alternative that best fits your application system and environment. Test results are given to illustrate the magnitude of improvements that can be achieved by using many of the alternatives covered in the book.

About the Author:

Gabrielle Wiorkowski is a senior DB2 consultant, founder of Gabrielle & Associates and affiliated with Codd & Date International. She has worked for IBM as an Advisory Systems Engineer specializing in DB2 and has contributed significantly to the design and development of over 25 application systems on DB2 since 1984. She has consulted for a number of companies including EDS, AT&T, Exxon, US LIFE Systems, Corp., Hogan Systems, Morgan Guarantee Trust, Citibank, and is an IBM Gold Consultant. She has been the president of DB2 Forum since 1988, the Southwest users group with a membership of over 100 DB2 professionals. She has lectured widely on DB2 to over 14,000 professionals in 27 countries on 6 continents, authored a 985 page book "DB2 for OS/390 Development for Performance" (ISBN 0-9668460-0-1), the book "DB2: Design and Development Guide" published by Addison-Wesley in three editions, over two dozen articles, and 1700 pages of seminar material.

Review:

For database administrators, developers, and more technical managers, this book is the definitive look under the hood into the mechanism that drives the operational engines of DB2. Those responsible for squeezing performance out of DB2 should get access to it. Study it, and reap the benefits. Lou Agosta, Consultant, Chicago, ACM Computing Reviews, Sept.1998. -- Lou Agosta, Consultant, Chicago, ACM Computing Reviews, Sept.1998.

Ive believed for some time that Gabrielle Wiorkowski knows as much as, or more than, anyone outside of IBMs DB2 development team about DB2's use of indexes, optimization, and other aspects of performance. This book is based on what she has learned, her direct experiences, and the experiences of other DB2 professionals with whom she comes in contact. ... It is you, the administrator, database designer, or application developer who applies its capabilities wisely or unwisely. This book provides practical information of use to you today in your job environment. Marilyn Bohl, Vice President, Work Process Systems, San Jose, CA. -- Marilyn Bohl, Vice President, Work Process Systems, San Jose, CA.

The book explains many things about DB2 use and workings in an easy to understand fashion. It is designed both for the beginner and intermediate to advanced DB2 person because most of us cannot be advanced in all DB2 topics. I never found any other book for DB2 OS/390 as useful as this one. Michael Hannan, Consultant, Melbourne, Australia. -- Michael Hannan, Consultant, Melbourne, Australia.