IBM DB2 9.7 Advanced Application Developer Cookbook and over one million other books are available for Amazon Kindle. Learn more
Buy New
$55.68
Qty:1
  • List Price: $64.99
  • Save: $9.31 (14%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
IBM DB2 9.7 Advanced Appl... has been added to your Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

IBM DB2 9.7 Advanced Application Developer Cookbook Paperback – March 14, 2012


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$55.68
$55.68 $78.48
Amazon%20Web%20Services



Frequently Bought Together

IBM DB2 9.7 Advanced Application Developer Cookbook + IBM DB2 9.7 Advanced Administration Cookbook
Price for both: $114.17

Buy the selected items together

Customers Who Bought This Item Also Bought

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 89%). Print edition purchase must be sold by Amazon. Learn more.


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 442 pages
  • Publisher: Packt Publishing (March 14, 2012)
  • Language: English
  • ISBN-10: 1849683964
  • ISBN-13: 978-1849683968
  • Product Dimensions: 9.2 x 7.5 x 0.9 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #2,409,607 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Sanjay Kumar

Sanjay Kumar started his career as a database developer and DB2 consultant in IBM India Software Labs. He is currently working as Database Architect for Data Warehouse Applications for an Investment banking firm. He has extensive experience in DB2 application development and performance tuning. He is an IBM certified application developer (DB2 9.7), IBM certified solution developer, and IBM Certified Advanced Database Administrator.

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

1 of 1 people found the following review helpful By Data Guy on May 18, 2012
Format: Paperback
This book shakes up the typical technology book with a cookbook metaphor and succeeds in delivering the best of both of those approaches.

The authors have obviously used the technology and clearly explain to the reader step-by-step tactics for tackling most of the important components of the DB2 application development life cycle. The book is divided into 9 chapters, each delivering a series of practical recipes for using, creating and managing various aspects of DB2 application programming. The recipes are well-written and easy to understand with lots of supporting code to guide you as you work through the recipe. The cover of the book references "over 70 practical recipes" but it sure seems like there are more than that.

The first chapter of the book covers recipes that focus on the application development enhancements made to DB2 9.7. This is an important chapter because sometimes new features get introduced so rapidly that developers do not get the chance to learn them before the next version comes out. Indeed, with DB2 10 being released in early April 2012, it is even more important to learn what DB2 9.7 added to the mix.

Other chapters I found quite useful were Chapter 5, which covers recipes for coding Java applications against DB2 databases; and Chapter 8 and 9, which covers recipes for monitoring and tuning your DB2 applications.

Of course, the trouble with recipes is that you rely on them when you want to make something specific. A book that contained a recipe for everything you ever wanted to do with DB2 is not practical though. You can, however, use many of the recipes as starting points for beginning the "dish" you wish to "cook" and then add to the recipe the additional "flourishes" you need to make the dish your own.

Whether you are a novice or a long-time DB2 coder this book will be helpful as you design, plan, develop, and optimize your DB2 9.7 applications and databases.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By W Boudville HALL OF FAMETOP 1000 REVIEWERVINE VOICE on May 8, 2012
Format: Paperback
I just reviewed the companion IBM DB2 9.7 Advanced Administration Cookbook to the current book. If you are seriously considering the latter, you might also check out the former. The materials in both books are complementary. The present text also presupposes considerable experience with writing long, complex SQL statements.

The 70 recipes offered cover numerous aspects of db2. Some involve the running of a SQL statement dynamically. This reflects the practical reality where you have some large data set and you are cogitating in real time. You have hypotheses that you want to quickly investigate. The text explains that the dynamic SQL statements are not compiled, by definition. Yes, there is a possible or probable loss of optimisation when you can't throw the compiler at it.

The book also shows that you won't get a fancy GUI. Have a gander at the screen captures, such as they are. The input is text. The output is text, and usually lots of it. Where typically you will then iterate over your SQL phrasing to truncate the output to something meaningful to you.

It's worth it if you get this book to quick skim over the recipes, to get a flavour of the breadth of what's available. You probably won't find an exact match to your immediate needs. That's a bit much to expect. But the amount of detailed explanations of each recipe is a good starting point for you to try to take the recipe and alter it for your tasks.

In terms of source code, java snippets are scattered throughout the book. They instruct in how to drive db2 by making SQL statements inside java code and then hooking up to db2 via pre-supplied libraries or classes. A little kludgy perhaps. But that is the reality of interfacing between java and db2.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
This is really the simplest overview - examples are trivial, the code for download is truly pathetic. I should have bought another one!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
This is a great DB2 9.7 application developer cookbook. This book offers great practices of DB2 9.7 features for developers. Each chapter of the book is organized with step by step instruction showing how to utilize any new features of DB2 9.7. I would recommend this cookbook to DBAs / developers. This is one of the great books helps to make learning and practicing DB2 LUW much easier and interesting.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
I first reviewed this book on June 7th, 2012, in the DB2 LUW Performance Blogs hosted by DBI Software. This review, due to size limitations, contains excerpts of my original review.

The book's subtitle claims "Over 70 practical recipes for advanced application development techniques with DB2". There may be more than this, certainly more if you consider all of the examples offered.

If I were the author, I would not have included DB2 "9.7" in the title. Many of the topics discussed are relevant to V9.1, V9.5, and even V10.1. It is unfortunate that DB2 LUW V10.1 became GA just as this book was being published, for I think many of the ideas and concepts are relevant and useful in V10.1 as well.

I've been a hard core DB2 LUW DBA since the early 90's. Application development and programming bores me ( thank goodness there are people in the world willing to practice this craft! ). But, let me "shoot you straight" - there are application design elements of this book that actually make the art of developing applications look appealing and interesting to me. Heck, I might even grab a keyboard and write a stored procedure someday just for the joy of it.

As a bonus, the book comes with electronic materials that provide many samples and examples of code. I can see this being a great advantage to anyone in a hurry to get quality applications written quickly.

Application Developers and Database Administrators should be able to find several helpful topics and advice within this book, and don't be misled by "9.7" in the title. Much of the book content is applicable to DB2 LUW V9.5 through V10.1.

My full review of this book can be found at: [...]
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again