(Carla Sadtler, John Adegbile, Erik Kirk, Joao Lopes, Rosaline Makar and Raghunath Nair) IBM WebSphere Process Server is a business integration server built to support solutions based on SOA. It plays a key role in the IBM SOA Foundation architecture by providing process services functionality. Anot

(Fred Sobotka) Perhaps one of the most surprising omissions at the IOD conference keynote sessions is any mention of IBM’s October 15th TPC-H benchmark (the same day the conference began), in which they fired up a battalion of hardware and software to achieve fastest ten terabyte data warehouse benc

(Paul Zikopoulos) As I’ve been introducing you to the IBM Data Studio integrated development environment (IDE) that’s new with DB2 9.5, I’ve shown you how to set up database connection objects and the actions that you can perform on them. In this article, I want to delve deeper into the overview dia

(Troy Coleman) DB2 stores table data in a table space and index data in an index space. The underlying data set holding this data is a VSAM dataset. Let’s examine the three options for creating and managing these datasets: DB2 managed, SMS managed and user managed.

(Roger E. Sanders) Organizations are generating more data now than at any other time. And the need to comply with legal and governmental regulations means that they’re keeping that data around for longer periods of time. The result: Databases are growing at an astonishing rate. In fact, according to

(Martin Packer) I was contacted by the team updating the SG24-7083 “DB2 Stored Procedures: Through The Call And Beyond” this past week. Their question was quite straightforward: “One of the statements in the book, in the chapter on WLM address space management states: To help analyze the use

(Kent Milligan) System i customers can receive lots of benefits from journaling their DB2 tables and files. First, journaling improves the recoverability of your databases, whether you’re trying to recover from a system failure or an uncompleted business transaction. Journaling is required for any a

(Sonali Surange, Shahneela Rahman and Mark Hager) With IBM pureQuery platform and Eclipse tools, rapidly build simple, high-performing data access layers and applications with much less code than JDBC and much higher productivity than any other Eclipse-based tools. (R)

In one of our previous blog post, we had covered, how in Oracle can we convert relational data to XML in vice-versa. Today we will get basic familiarity with XML functions in DB2 LUW. IBM has also provided very strong XML support in DB2 LUW. DB2 LUW contains certain built-in SQL/XML functions which

(Robert Catterall) I am writing this post in Athens, Greece, where I am participating in the 2007 International DB2 Users Group (IDUG) European Conference. I have been to a number of IDUG conferences over the years, in various parts of the world, but the 2007 Athens event has been, for me, one of th