You have to be running at least V5R4 to load DB2 Web Query, and there are some PTFs to install. But help is just a phone call away.

By Chris Smith

Those folks at Centerfield Technology certainly are on their toes. An opportunity arises in their field (which is databases), and they're on it. This week the company introduced a new service: installing, configuring, and verifying the functionality of DB2 Web Query for System i.

When I saw the Centerfield announcement, I was a bit puzzled because I had been reading about the application's features and how easy Web Query is to use: so easy, it's said, even a manager can do it (just kidding!). I never dreamed, however, that it would require a consultant to install and configure it.

By Gene Cobb

In July of 2007, IBM announced DB2 Web Query for System i, a product positioned as a query and reporting tool for the System i and the strategic enhancement to the Query/400 tool. DB2 Web Query has many advantages over Query/400. Most notably, it provides modernized development and end-user interfaces via a Web browser as well as modern report output formats such as HTML to the browser, Excel spreadsheets, and PDF. For more information on DB2 Web Query, download the IBM Redbook titled Getting Started with DB2 Web Query for System i.

Whether you want to obtain an IBM certified DB2 professional certification or simply become well-rounded in the fundamental concepts of DB2 and general database theory, this is your book.

Roger E. Sanders has created one of today's greatest technical certification books, DB2 9 Fundamentals, to prepare you for everything you need to know to become DB2 9 certified per IBM's standards.

Sanders kicks things off with a chapter dedicated to identifying the various types of DB2 professional certifications that are available and the professional roles at which each is aimed. He also walks you through the complete process of obtaining your certification, first taking you through the steps to register for the exam and then providing examples of what to expect on the exam in terms of its format. If you were at all wondering what to expect, then wonder no more: It's all clearly spelled out in his opening dialog!