Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
IBM DB2 9.7 Advanced Application Developer Cookbook Paperback – March 14, 2012
|New from||Used from|
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
About the Author
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.
Mohankumar Saraswatipura started his career in DB2 8.1, worked as database application developer, performance consultant in IBM Software Labs, India. He is currently working as Lead DB2 Database Administrator helping application developers on Balanced Warehouse, Siebel and SAP implementations. He is experienced in DB2 application performance tuning and design. He is an IBM certified application developer, Infosphere Solution Designer, XML, Stored Procedure along with Advanced Database administrator. He is an active member of IDUG India and a IBM Information Champion.
Top Customer Reviews
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.
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.
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: [...]
Most Recent Customer Reviews
This is really the simplest overview - examples are trivial, the code for download is truly pathetic. I should have bought another one!Published on August 2, 2012 by Eugene Zhukovsky