(Paul Tuohy) In Part 1 of this article, I discussed some of the main components of Web services. In this article, I will show you how you can use WDSC to generate a Web service, even if you have no knowledge of Java, XML, or WebSphere Application Server (WAS).

(Willie Favero) You put on the fixes and patches and you did all of the testing. March 11 came and went and you had minimal if no problems with the changed date for daylight savings time (DST). You know all about the potential problems moving the forward a few weeks and you were ready. Job complete,

(Simon Harris and Susanne Englert) Combine WebSphere DataStage and WebSphere Federation Server to provide an efficient and flexible architecture for moving and transforming data. This article promotes the use of WebSphere Federation Server as a “data pre-processor” for DataStage, and demonstrates si

Set aside old notions of what a mainframe can and can’t do. DB2 Magazine columnist Robert Catterall explains what many companies already know: the mainframe is a great platform for the most modern IT initiatives, including those that use service-oriented architectures, XML, J2EE applications, and mo

(Willie Favero) Now there’s a question I’ve heard for years, maybe as long as I have been working with DB2. Probably one of the primary ways to add rows (data) to an already existing table, INSERT has long been a point of concern for many. It’s discussed in books, articles, and presentations and eve

(Vasantha Jayakumar) Learn how to alter IBM DB2 for z/OS stored procedures using non-destructuve alteration techniques now available in the Procedure Designer, part of the IBM Database Add-ins for Visual Studio 2005. You can use the Procedure Designer to alter both external and native SQL procedures

(Brian Holroyd) In Part 1 of this article, we looked at the benefits of DB2 V8 for PeopleSoft customers in the areas of Scalability and Performance. Part 2 will look at Availability, SQL Enhancements, Utilities and Network Computing.

(Vincent Corvinelli and Samir Kapoor) Running large queries efficiently is a top performance challenge in a business intelligence environment. Learn techniques for improving IBM DB2 data server query performance in this environment. Walk through various methods, step-by-step, then experiment on your

(Manu T. George) Java 2 Platform, Enterprise Edition (J2EE) 1.4 supports two types of Web service endpoints: Plain Old Java Object (POJO) and Enterprise JavaBeans (EJB) endpoints. IBM Websphere Application Server Community Edition (also referred to as Community Edition in this tutorial) is a J2EE 1.

(Scott Lashley) IBM Informix Dynamic Server (IDS) uses memory (bufferpool) to cache application transaction updates (inserts/updates/deletes). This improves performance dramatically because the server does not need to flush transactions to stable storage (disk) upon commit. The updates are also logi