Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

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

DB2 9 for Developers [Paperback]

by Philip K. Gunning
4.6 out of 5 stars  See all reviews (12 customer reviews)

List Price: $64.95
Price: $61.70 & FREE Shipping. Details
You Save: $3.25 (5%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it Monday, April 28? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

March 1, 2008 1583470719 978-1583470718 1
Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.

Customers Who Viewed This Item Also Viewed

Editorial Reviews

About the Author

Philip K. Gunning is the principal of Gunning Technology Solutions, which provides DB2 consulting to firms throughout North America and Europe, and is active in the International DB2 User Group where he serves on the Solutions Journal editorial board. He is the author of DB2 Universal Database Handbook for Windows, UNIX, and Linux. He lives in Sinking Springs, Pennsylvania.

Product Details

  • Paperback: 550 pages
  • Publisher: Mc Press; 1 edition (March 1, 2008)
  • Language: English
  • ISBN-10: 1583470719
  • ISBN-13: 978-1583470718
  • Product Dimensions: 9 x 7.1 x 1.1 inches
  • Shipping Weight: 1.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Best Sellers Rank: #2,244,138 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews
5 of 5 people found the following review helpful
5.0 out of 5 stars Great book for Developers and Development DBAs March 6, 2008
This is a great book for developers because covers pureXML and other features and great to for DBAs the chapter on monitoring is a must have when you are in trouble with your database

Just keep in mind that this book is focues on the LUW(Linux, Unix and Windows) version of DB2, I say this because a friend of mine bought for using with z/OS by mistake.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars Another excellent reference February 19, 2008
By Leo
This book is a must have for anyone who develops application code or administers DB2 databases on the windows/unix/linux platform.

The chapter on understand the DB2 optimizer is required reading because it provides deep insight into how DB2 will go about getting the data out of your relational database. Understanding this is fundamental for performance in your application.

The chapters on monitoring and peformance tuning are also very insightful and relay the authors years of experience in a very straight forward manner. Using the methods described in this book makes it easy to put procedures in place to track the performance of your database over time, and to spot problems before they start.

This book is a "must have".
Comment | 
Was this review helpful to you?
6 of 7 people found the following review helpful
2.0 out of 5 stars Not very much useful July 4, 2009
Format:Paperback|Verified Purchase
This book only provides very high level information about DB2 features and doesn't have the level of detail that I wished for. I purchased this book based on other's review; however, I think that it is not useful for most people who is going to do developement on DB2.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Excellent Guide to the Newest Version February 19, 2008
By D. Tuck
Mr. Gunning's expertise provided the information I needed about the newest version of DB2. Service Oriented Architecture, in Chapter 6, and XML, in Chapter 9, were clearly written and understandable.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Excellent DB2 reading February 8, 2011
Phil's book focuses on development for performance - whether you decide to use pureXML or not, this is a must-read before you commence writing code! It contains excellent insight & tips for performance monitoring and tuning. Primarily written for DB2 on the distributed platforms, it serves as a good supplemental reference for SQL used with DB2 on the mainframe as well.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
3.0 out of 5 stars DB2 reference for XML impacts in Version 9 May 27, 2010
Format:Paperback|Verified Purchase
This reference book covers the XML capabilities added to DB2 in Version 9. Other updates are identified with minimal explanation or examples.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Outstanding Technical book on DB2
We just recently migrated to 9.5 and I was looking for tips on monitoring and tuning. The information in Chapters 8 & 9, Bufferpool Tuning and Monitoring was very beneficial. Read more
Published 18 months ago by CLG
5.0 out of 5 stars DB2 9 For Developers- Perfect Balance !

This is another great DB2 book. I really like the blend of XML developer, database designer, DBA, and architecture chapters, which helps plug any holes in... Read more
Published on November 10, 2008 by Terry Mason
5.0 out of 5 stars Excellent DB2 V9 Reference
This book is a must have for anyone working with DB2 databases on the linux, unix, or windows platforms. Read more
Published on October 30, 2008 by Kevin Eberhart
5.0 out of 5 stars Mr. Gunning has done it again
Mr. Gunning has done it again!
Having studied under Phil Gunning and knowing the dept of his expertise this book brought to life real world experiences in a classroom like... Read more
Published on March 3, 2008 by Dewayne W. Stansell
5.0 out of 5 stars Good Overview of DB2 9 XML Development and Performance
I bought this book because I needed to get up to speed real fast on using the new XML data type and Developer Workbench, and Chapter 2, 3, 4, and 5 contained everything I needed to... Read more
Published on February 24, 2008 by Seth Heisler
5.0 out of 5 stars A Book for DB2 Practioners
I was looking for a good book on DB2 9 based on practical experience and this book is just what I was looking for. Read more
Published on February 16, 2008 by Gaile Mcgettigan
Search Customer Reviews
Only search this product's reviews

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


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category