DB2 Developer's Guide / Edition 5

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (1) from $156.64   
  • Used (8) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2011

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Brand new and unread! Join our growing list of satisfied customers!

Ships from: Phoenix, MD

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


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
Read More Show Less

Product Details

  • ISBN-13: 9780672326134
  • Publisher: Sams
  • Publication date: 5/11/2004
  • Edition description: Subsequent
  • Edition number: 5
  • Pages: 1487
  • Product dimensions: 7.38 (w) x 9.04 (h) x 2.40 (d)

Meet 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, including systems analysis and design, database and system administration, data analysis, and developing and teaching DB2 and Sybase classes. Craig is a regular lecturer at industry conferences and also frequently writes for computer industry publications.

Read More Show Less

Table of Contents



1. The Magic Words.

2. Data Manipulation Guidelines.

3. Using DB2 Functions.

4. Using DB2 User-Defined Functions and Data Types.

5. Data Definition Guidelines.

6. DB2 Indexes.

7. Database Change Management and Schema Evolution.

8. Using DB2 Triggers for Integrity.

9. Large Objects and Object/Relational Databases.

10. DB2 Security and Authorization.


11. Using DB2 in an Application Program.

12. Dynamic SQL Programming.

13. Program Preparation.

14. Alternative DB2 Application Development Methods.

15. Using DB2 Stored Procedures.

16. The Procedural DBA.

17. DB2 and the Internet.


18. The Doors to DB2.

19. Data Sharing.

20. DB2 Behind the Scenes.

21. The Optimizer.

22. The Table-Based Infrastructure of DB2.

23. Locking DB2 Data.


24. Traditional DB2 Performance Monitoring.

25. Using EXPLAIN.

26. DB2 Object Monitoring Using the DB2 Catalog and RTS.


27. Tuning DB2's Environment.

28. Tuning DB2's Components.

29. DB2 Resource Governing.


30. An Introduction to DB2 Utilities.

31. Data Consistency Utilities.

32. Backup and Recovery Utilities.

33. Data Organization Utilities.

34. Catalog Manipulation Utilities.

35. Stand-alone Utilities and Sample Programs.

36. DB2 Commands.

37. DB2 Utility and Command Guidelines.

38. DB2 Contingency Planning.


39. Components of a Total DB2 Solution.

40. Organizational Issues.


41. DRDA.

42. Distributed DB2.

43. DB2 Connect.

44. Distribution Guidelines.

45. Data Warehousing with DB2.


Web 1. Special Consideration for DB2 Version 6.

Web 2. Short Summary of DB2 V4 Through V6 Changes.

Web 3. Type 1 Indexes.


Appendix A. DB2 Sample Tables.

Appendix B. DB2 Tools Vendors.

Appendix C. Valid DB2 Data Types.

Appendix D. DB2 Limits.

Appendix E. DB2 on Other Platforms.

Appendix F. DB2 Version 7 Overview.

Appendix G. DB2 Version 8 Overview.

Appendix H. Reorganizing the DB2 Catalog.


Read More Show Less

Customer Reviews

Average Rating 4.5
( 3 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 4 Customer Reviews
  • Anonymous

    Posted November 2, 2004

    very extensive

    [A review of the 5th EDITION 2004.] IBM invented relational databases and its DB2 is one of the company's core technologies. While it trails Oracle in market share, the capabilities as shown here by Mullins are probably at least the equal of Oracle's 10g. This book is designed for a full time DB2 administrator or developer, who needs an extensive reference on it. It's fair to say that you would not want to learn the theory of relational databases from this book. Sadly, there is only one, passing reference to E F Codd, in the context of normalisation of data. Minimal acknowledgment of the founder of relational modelling. Seek a learning of theory elsewhere. Instead, the book focuses on all the options built into DB2. By now, possibly person-centuries of IBM's programmer sweat have gone int this latest version 8. You can take advantage of this accrued expertise. Though the time needed to absorb a chapter may be nontrivial.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted April 15, 2002

    A very Good reference

    This is an excellent reference. If you truly want to understand the workings of DB2 you need this book in your library. It will give you the indepth details. However,it is not a book for showing you how to do something. There are other books more suitable for that.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 11, 2001

    Great Book & Reference

    This is a great book packed with lots of information on DB2 and also SQL. Although its not a SQL book it has some good examples of real world scripts. Good reference for any programmer who uses DB2, beginner or experienced.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 31, 2000

    The definitive guide to DB2

    The latest edition of Craig Mullins DB2 Developers Guide updated to include V6. This is an excellent reference book covering all aspects of DB2. A must for anyone working with DB2. Highly recommended.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 4 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)