Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

DB2 Developer's Guide [Paperback]

Craig Mullins
5.0 out of 5 stars  See all reviews (1 customer review)

Available from these sellers.


Amazon Price New from Used from
Hardcover --  
Paperback 47.89  
Paperback, 13 Oct 1997 --  
Amazon.co.uk Trade-In Store
Did you know you can use your mobile to trade in your unwanted books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details or check out the Trade-In Amazon Mobile App Guidelines on how to trade in using a smartphone. Learn more.

Book Description

13 Oct 1997 0672311682 978-0672311680 3

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.

Product details

  • Paperback: 1440 pages
  • Publisher: Sams; 3 edition (13 Oct 1997)
  • Language: English
  • ISBN-10: 0672311682
  • ISBN-13: 978-0672311680
  • Product Dimensions: 5.7 x 19 x 22.9 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 3,564,924 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

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.


  • 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
--This text refers to an out of print or unavailable edition of this title.

About the Author

Craig S. Mullins is Director of DB2 Technology Planning for BMC Software, Inc. He has extensive experience in all facets of database systems development, teaching database management courses, systems analysis and design, database and system administration, and data analysis. He has worked with DB2 for OS/390 since Version 1 and has spoken on DB2 and database management at many database-related events worldwide.

--This text refers to an out of print or unavailable edition of this title.

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4 star
3 star
2 star
1 star
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5 of 7 people found the following review helpful
5.0 out of 5 stars The definitive book on DB2 21 May 1998
By A Customer
This is by far the best book on DB2 and all versions from 3 to 5. Highly Recommended reading for everyone using DB2, from DBAs to Client/Server Developers. The only reason I did not rate this book a 10 was there could be more information on developing and designing parallel queries in Version 4 and 5.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.3 out of 5 stars  27 reviews
24 of 24 people found the following review helpful
4.0 out of 5 stars DB2 Developer's Guide - 4th Edition 10 Dec 2001
By Claude Wright - Published on Amazon.com
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 25 Jun 2001
By BetsyPreston - Published on Amazon.com
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! 22 Jun 2001
By A Customer - Published on Amazon.com
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.
19 of 23 people found the following review helpful
3.0 out of 5 stars Very disappointed in DB2 V6 coverage. 16 Nov 2000
By Gene Geiler - Published on Amazon.com
I have over 10 years of DB2 DBA experience and see this book owned by every DBA. This is a useful book but with many shortcomings. I liked the Third Edition better and would not buy this book to move from V5 to V6. The author attempts to cram a bookshelf of DB2 manuals and IBM Red Books into one book. No wander it is incomplete and is full of errors and inaccuracies. The book grew from 1,395 pages to 1,640 pages in current edition. I expected many corrections from previous edition but many errors remain. For example Craig has no mention of UNLOAD EXTERNAL option for REORG utility neither for DB2 V5 nor V6. What about INSERT via SELECT ? REFORMAT ? Left join example, and so on. The list can go on for pages. The current fourth addition is even worst then previous. Many errors from the third edition are not corrected, DB2 V6 features are scattered thruout the book without clear distinction from earlier versions. In this edition, the author has abandoned clear identification of material by DB2 version. New DB2 V6 features are summarized in useless three page appendix at the end of the book. After discovering several errors, I found myself always double checking the book against IBM manuals. I would certainly not use this book the "Bible".
8 of 9 people found the following review helpful
4.0 out of 5 stars A great book for a DB2 professional. 3 Jan 2002
By Deepak D Manjarekar - Published on Amazon.com
If you are a savvy DB2 developer/DBA, you ought to own this book. This book will take you from the basics to the intricate details about DB2 internals. It also talks about data warehousing briefly so one can get an idea.
If you work with DB2 then you should own this book as a handy reference. I have benefitted with this book a lot and I would like to thank Craig for that!!! Craig keep writing.....
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category