We see that javascript is disabled or not supported by your browser - javascript is needed for important actions on the site. Read more

What's New - Home - Login

Member $avings: $81,542,219.61 | Books Available: 800,178 | Members Online: 277

Swap Used Books - Buy New Books at Great Prices!

How To Swap Books Sign Up Search submenu

PBS Market (New Books)

Gift Buying Guide

Book Browser Advanced Search Books Posted Today Member Book Reviews Award Winning Books NYT Best Sellers Amazon Best Sellers Most Traveled Copies Club Wish List

Discussion Forums Book Lists

Club Lists My Book Lists My Watched Lists Create a List

Blog Donations

School Donation Program In Memory of... Military Donation Program Friends of PBS

Box-O-Books Maps The Eclectic Pen Fun Stuff

20 Questions Sudoku Bookmark Creator

Top 100

Requests Posts Swappers Referrers Reviewers

Pulse of PBS Spread The Word

Invite Friends Bookmarks Facebook Page Facebook App More Ways...

Photo Gallery Recipes Club Tag Cloud Member Testimonials

Help Center submenu

How To Swap Books Browse Help Docs Ask the Librarian PBS Member Icons Live Help

Kiosk

PBS Market (New Books) Go Shopping Buy Credits Buy PBS Money Upgrade Membership Gift Certificates Transfer Credits

Need Help?

390 Development for Performance (Volume 2)

DB2 for Z/OS and Os/390 Development for Performance - Volume 2
Author: Gabrielle Wiorkowski

DB2 for z/OS and OS/390 Development for Performance in its fourth edition is the first 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 ha... more »rd cover book in two volumes. Having the most current information available and integrated into the book is a major advantage. 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 The fourth edition of the book is published in two volumes due to its size with the inclusion of V6 and V7 features and facilities. 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. 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.

ISBN-13: 9780966846065
ISBN-10: 0966846060
Publication Date: 2/2002
Pages: 700
Rating:

0 stars, based on 0 rating

Publisher: Gabrielle Associates
Book Type: Hardcover
Members Wishing: 0
Reviews: Amazon | Write a Review

Genres:

Back to the Top ↑

Search - DB2 for Z/OS and Os/390 Development for Performance (Volume 2)

Loading...