Team with the best
Db2® LUW Performance Tools
company in the World

IBM DB2 9.7 Advanced Application Developer Cookbook

June 7, 2012, 2:02 pm
Posted by Scott in DB2 Performance How-To
I've recently had the good fortune of reviewing the book IBM DB2 9.7 Advanced Application Developer Cookbook by author Sanjay Kumar. Sanjay will be the special guest of The DB2Night Show™ on 15 June 2012 at 10am CDT for Episode #85 talking about OLAP, Stored Procedures, Optimization Profiles, PL/SQL, SQL tips, and more! Frankly, I think the book title does this book a disservice, for the content is much broader than just application development. DBAs should also find the book to be a very useful resource...


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 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 type guy 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.

A Closer Look

There are over 400 pages in this book. A blog review can't do it full justice. But, I'll share some bullet points that I found interesting or helpful:
  • You will find discussion, tips, and advice for DB2 9.7 Oracle Application Enablement. For Oracle DBAs, welcome home to DB2 LUW.
  • Security is a necessary evil, and security options and methods in DB2 LUW continue to improve. You will find information about using DB2 security wisely.
  • I like the discussion about Global Temporary Tables, and the use of indexes.
  • Using Generated Columns is a very important topic.
  • I like Chapter 4 on Procedures, Functions, and Triggers.
  • For old timers like me, Java is still a coffee beverage. But, if Java is your language, you'll find good ideas about Java application development.
  • Chapters 7, 8, and 9 seem more in the DBA world to me, but application development folks may likely benefit from the information shared on OLAP functions, Explains, db2exfmt, packages, registry variables, monitoring, insert performance, and SQL performance tips.


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.

Of course, there is something missing from the book - a shameless marketing plug for DBI. icon_biggrin

DBI is Your Trusted Partner
for Breakthrough DB2 Performance Solutions
that Deliver Invaluable Results
for Organizations having the most Demanding Requirements
and Discriminating Preferences

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.


By the way, during Episode #85 of The DB2Night Show™, we will be giving away two FREE copies of the book so be sure to join our studio audience!

Share the love of DB2

Do your friends and followers a favor and let them know about this DB2 book review: icon_wink

Printer friendly