comatco

DB2 for z/OS and OS/390 Development for Performance in its fourth edition is the only book to include the features and facilities of V7 integrated into the book. This edition even has V7, V6, or V5 APAR number noted with the first of occurrence of a feature specific to the version or APAR in the index. Three DB2 professionals indexed the now hard cover book.

The book is published in two volumes due to its size. The table of contents is in Volume 1 and the index is in Volume 2. The two volumes cross reference each other. Please order both volumes which is the same price as the third edition in one volume. The complete title and ISBN numbers (primary key at book stores) are:

DB2 for z/OS and OS/390 Development for Performance Volume 1 of 2

ISBN 0-9668460-5-2

DB2 for z/OS and OS/390 Development for Performance Volume 2 of 2

ISBN 0-9668460-6-0

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 utilities including enhancements in V6 and V7 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. The following list of chapters give you an idea of the content.

1. Concepts and Components

2. Creating STOGROUPs, Databases, and Buffer Pools

3. Creating Tablespaces

4. Creating Tables and Views

5. Index Usage for Performance

6. Index Design for Performance

7. The Basics of SQL Data Manipulation

8. Concurrency Control

9. Program Development

10. Batch Processing

11.Triggering Actions in DB2

12. Stored Procedures

13. User-Defined Function

14. Program Preparation and Execution

15. Join Performance

16. Subselects and Table Expressions

17. Parallel Processing

18. Programming for Performance

19. The Optimizer

20. Explaining the Access Path Chosen by the Optimizer

21. Load and Check Data Utilities

22. Runstats and Reorganization

23. Copy, Quiesce, Report, Rebuild, Recover, & Rebuild

If you would like to know what is in each chapter, go to www.GabrielleDB2.com and click on "Table of contents".

Purchase of a hardcopy of the book includes one year of web access. A CD of the book is also available. Web access and the CD provides for reading, searching, cut/paste of example SQL, utility statements, JCL, CLISTs, and more. You can also download the book or one or more chapters and use it from your PC or print it using a free copy of Adobe Acrobat Reader. Having the most current information available and integrated into the book is a major advantage.

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 six 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 16,000 course attendees in 27 countries on 6 continents, and has grown with DB2 to 1,415 pages in two volumes.

The two volume book is available from:

http://www.gabrielledb2.com (immediate web access and shipment)

http://www.amazon.com

http://www.borders.com

http://www.barnesandnoble.com (click on “Advanced Search” if you search by ISBN)

You can search on any of following items (not necessary for the first web site) :

DB2 for z/OS and OS/390 Development for Performance Volume 1 of 2

DB2 for z/OS and OS/390 Development for Performance Volume 2 of 2

0966846052 and 0966846060 (ISBN numbers)

Gabrielle Wiorkowski

Most book stores will special order the book for you if they do not have it in stock including:

Barnes and Nobel Book Stores

Borders Book Stores

Franklin Book Co., Inc.

Gothic Book Shop

CROMLAND, Inc.

Stacy’s Book Stores

Chapters Inc.

Tech-Materials Int’l Inc.

Most technical book stores throughout the world have ordered previous editions of the book.