(Roland Barcia, Gang Chen, Thomas Gissel and Mandar U Jog) IBM WebSphere sMash is a development and execution platform that enables you to quickly and simply deliver dynamic Web 2.0 based applications. The Web itself is the epitome of a scalable, flexible system. This article is the first in a serie

(Troy Coleman) Implementing new features and functions that improve SQL performance has been a long-time challenge for IBM, because these enhancements require a rebind of all the packages in the catalog. For years many customers would apply maintenance and upgrades, but refuse to rebind out of fear

(Farzad Farahbod and Ajay Aggrwal) Learn how the IBM Database Add-Ins for Microsoft Visual Studio tool set supports IBM data server Web services development. Walk through the creation of a data Web service, and see how it can be deployed to easily access IBM DB2 or IBM Informix databases from your W

(Fred Sobotka) This DB2 mystery took me by surprise. For many years, one of my standard recommendations for my DB2 customers has been (and still is) to encapsulate commonly used SQL expressions into SQL User Defined Functions (UDFs), an approach that generally pays off well. In this case, however, w

(Willie Favero) One of the more “popular” solutions to a query performance dilemma is an index. Adding an index can fix a lot of SQL issues. However, adding an index does come with a cost; the additional index will take up additional disk space. You can get into a game of trying to decide which is t

(Robert Catterall) In an entry posted to this blog last November, I wrote about some of the benefits of using native SQL procedures (which one can create and deploy with DB2 for z/OS V9 in New Function Mode) versus external SQL procedures (these get turned into C language executables under the cover

(Ray Willoughby) Previously I have blogged about how DB2 Optimization Expert can help developers produce better performing queries early on during development. So with good query tuning it should be possible to drive down CPU costs for database applications.

(Paolo Bruni, Sean A. Dunn, Howard Hirsch, Norihiko Nakajima and Suresh Sane) DB2 packages were introduced with DB2 V2.3 in 1993. During the 15 years that have elapsed, a lot has changed. In particular, there is a more widespread use of distributed computing, Java language, new tools and upgrades in

(Stephanie J. Hazlewood, Allan Luo and Martin Oberhofer) This tutorial (the first in this series) presents a high-level overview of how to integrate IBM InfoSphere Master Data Management (MDM) Server with another Enterprise Information System (EIS) using IBM WebSphere Process Server. (R)

(Guogen (Gene) Zhang) One of the key differences of XML from the Large Object (LOB) types in DB2 is that XML data can be indexed. The XML indexes supported in DB2 9 are also called XML value indexes, and queries on XML can use these indexes for performance.