DB2 Developer's Guide (5th Edition) [Paperback]

Craig S. Mullins (Author)

Book Description

ISBN-10: 0672326132 | ISBN-13: 978-0672326134 | Publication Date: May 21, 2004 | Edition: 5

Learn the best techniques and tricks from expert author Craig Mullins. Apply these real-world pieces of advice, undocumented tips, solutions, projects, and techniques to your own database management system. Mullins gives you what you need to take your DB2 development to the next level.

Written by a developer for developers, DB2 Developer¿s Guide, Fifth Edition provides a solutions-oriented approach to learning the foundation and capabilities of this latest version of the world¿s number one database management system.

LEARN THE CONCEPTS AND BUILD THE APPLICATIONS

• Implement innovative shortcuts, tips, tricks, techniques, and development guidelines to optimize all facets of DB2 development and administration
• Understand the guidelines for binding DB2 application plans and packages
• Use expert advice to implement distributed DB2 applications
• Connect your DB2 databases to the World Wide Web
• Review exhaustive coverage of V6 topics¿including triggers, user-defined functions, stored procedure extensions, predictive governing, hiperspace bufferpools, the REBUILD utility, the DSSIZE parameter, user-defined distinct types, auxiliary tables, and more
• Read implementation information and guidance for large objects to store multimedia data¿such as audio, video, and images¿in your DB2 for OS/390 databases (BLOBs, CLOBs, DBCLOBs, and DB2 extenders)
• Learn how and why to use the new EXPLAIN tables - DSN_STATEMNT_TABLE and DSN_FUNCTION_TABLE
• Discover how to implement a procedural DBA function to manage triggers, stored procedures, and UDFs

Editorial Reviews

Review

DB2 performance techniques for applications programs! This book explains the development environments of DB2. "Includes many tips and experience-based techniques. Discusses encoding efficient SQL, monitoring, and tuning DB2 performance". Covers Version 2.3. -- Sams Pub. --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

DB2 Developers Guide, Third Edition is a comprehensive guide to DB2 for Developers and Administartors. It serves as the blueprint for implementing optimized DB2 application systems. The book shows readers how to: Build high-performance DB2 application systems, Administer and support large DB2 databases, Create an optimal organization, for supporting and using DB2, Proactively monitor and tune, DB2 subsystems and programs. This edition is completely updated to include the following topics: Latest versions of DB2 on MVS and Versions 4 and 5, Using stored procedures, Outer joins, Data sharing, Sysplex, Check constraints, Enhanced utilities, Temporary tables, Dynamic SQL security enhancements, Accessing DB2 via the World Wide Web, ODBC, CICS, TSO, IMS, and the Call Attach Facility. --This text refers to an out of print or unavailable edition of this title.

See all Editorial Reviews

Product Details

• Paperback: 1512 pages
• Publisher: Sams; 5 edition (May 21, 2004)
• Language: English
• ISBN-10: 0672326132
• ISBN-13: 978-0672326134
• Product Dimensions: 9.1 x 7.4 x 2.5 inches
• Shipping Weight: 5.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (25 customer reviews)
• Amazon Best Sellers Rank: #812,077 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

23 of 23 people found the following review helpful:

4.0 out of 5 stars DB2 Developer's Guide - 4th Edition, December 9, 2001

By 

Claude Wright (Pasadena, Maryland United States) - See all my reviews

This review is from: DB2 Developer's Guide (Hardcover)

Being a mainframe DB2 DBA for IBM Global Services, I found this book useful but not the "Bible" that some have branded it. It covers a wide array of topics relating to mainframe DB2. As some have indicated this is not a text for the UNIX or WINDOWS environment. It is exclusively for OS/390. It is a great starting point for someone looking to gain an overall knowledge of how DB2 works in that environment. But, here again, a text short on depth in many areas. But, in defense of any author trying to put together a text on DB2, there are just too many areas of depth that would have to be covered. I would like to see a text that covers typical knowledge areas and scenarios that a DB2 DBA would encounter on a daily basis and give solutions on the problem. A text that could be used as a training manual for people who want to become a certified DB2 DBA. Still, if you are looking for the one book you should have to begin with, this is the best one so far.

27 of 29 people found the following review helpful:

3.0 out of 5 stars Index is Sorely Limited, June 25, 2001

By 

BetsyPreston "[e-mail]" (St. Paul, MN USA) - See all my reviews

This review is from: DB2 Developer's Guide (Hardcover)

I am an experienced COBOL and DB2 programmer and purchased this book to use as a reference. It does cover a lot of material and co-workers use it frequently as a source for answers to in depth questions not available in other references. There is a lot of good stuff in this book.

However, I find it extremely difficult to use as a reference because the index seldom contains an entry relevant to my question. There is a LOT of information in this book and the index could stand to be several times larger in order to successfully direct you to that information. Unless you already know what you're looking for, chances are slim that you will find it in the index.

For example, I found a parameter in a SELECT statement "WITH UR" and needed to know what it meant. There was no entry under "WITH" nor "UR". There was nothing about this parm in the index under "SELECT" either. I had to go to the online IBM manuals to find out that "UR" is an isolation level and was then able to go back to the "DB2 Developer's Guide" index to find the information that I needed indexed under "isolation level".

My experience is almost exactly the same every time that I try to use this book. Again - there's a lot of info and I like the book when I do find what I want, but it be warned that you may also have difficulty using the book as a reference.

12 of 13 people found the following review helpful:

5.0 out of 5 stars What a winner!, June 22, 2001

By A Customer

This review is from: DB2 Developer's Guide (Hardcover)

This is the first time I have used any of Craig S. Mullins's books. I found it to be indispensible for those who wish to have a clear and readable companion to help them with their understanding of DB2 UDB for OS/390. Although IBM's manuals online are essential for the minute details, this book helps simplify matters so that you can apply the required jobs, utilities, names and so on in a coherent and safe way. It probably means thatyou have the equivalent of 2 years or more DBA experience just by keeping it on your desk. As a mainframe programmer, I have found that it has enabled me to support DB2 Databases with an expertise which would have taken me a number of years to acquire without Mr Mullins's help. I must thank him for giving me a big boost to my career.