(Howard Fosdick) Have you considered taking IBM’s advanced DBA exam? IBM certified DB2 DBAs need only pass one test (#704) to attain the highest DB2 DBA credential.

(Patrick Ryan, Amr Khafagy, Brian De Pradine, Frank Pani, Hong Min and G Michael Connolly) In this IBM Redbook, we describe how to configure the various components of an e-business solution to exploit the availability and scalability benefits of zSeries and Parallel Sysplex using multiple LPARs runn

(Tyler Anderson) IBM Rational Systems Developer was launched in February as a tool to help software architects and model-driven developers build complex, large-scale applications. Rational Systems Developer is based on the Eclipse platform, an open platform that allows developers to extend the Ratio

(Willie Favero) Does this sound like the beginning of a discussion about one aspect of indexing in DB2 for z/OS Version 8? Well, it is.

(Chris Eaton) To date, I have talked about a number of aggregate functions that can be pretty powerful with analytic queries. But what I find even more interesting is the windowing clause that you can add onto some of these aggregates. This is the part of the OVER () clause that I have not described

(Craig S Mullins) Keeping up-to-date with the latest and greatest DB2 versions and functionality can be a time-consuming task. Every 18 to 36 months IBM announces a new version of DB2 with even more features and functionality than ever before.

Take an in-depth look at how IBM WebSphere solutions can be used in a Service-Oriented Architecture to unite scattered information, organize business processes and improve responsiveness in an affordable and productive manner. (R)

(Jack Boswell) This article provides steps for setting up the data model for a DB2 Content Manager system. The new data model adds the flexibility to have hierarchal child components.

(David Beulke) Web services provide a way to simplify processing and shield developers from the complexity of underlying systems. The simpler things become for developers, however, the more complicated they become for those in IT support and management.

(Craig S Mullins) I frequently get e-mail from folks asking about ways to accomplish things in DB2 and SQL. A recent question I got went something like this: Is there any option to check whether data “IS NUMERIC” in a DB2 table? We want to examine CHAR data but return only those where the entire