(Bharath Sriram, Harshavardhan Changappa and Priyambada Behera) Use the UPDATE STATISTICS statement in IBM Informix Dynamic Server (IDS) to get the moust out of the database optimizer. Get a brief overview of this SQL statement and see how it can be used for a variety of problems. Discover the impor

(Theresa (Tong) Xu) Many experienced DBAs and developers found it difficult to change the column definition of an existing table. Why? Because the longer the table lives, the more objects become dependent on its definition.

(Michael L. Pauser and Patsy Yu) IBM Data Studio V1.1 contains many new features, one of which is Data Web Services. Data Web Services allows you to quickly and easily expose database operations (SQL SELECT, INSERT, UPDATE, and DELETE) and stored procedures CALLs as a Web service operation to client

(David Beulke) DB2 9 for z/OS offers many new performance features. The one I find the most exciting combines DB2 9 and pureQuery to convert dynamic JDBC SQL applications into static transactions. This combination, which uses the new IBM Data Server Driver for JDBC, eliminates the overhead of dynami

(Kent Milligan) Is there a way to access the SQL Server Database without using DB2 Integrator or WEBSPHERE Integrator? Can it be done using Java? (R)

(Susan Visser) Available now… an electronic version of the very popular flashbook by Carlton Doe: IBM Informix Dynamic Server: The Next Generation OLTP Data Server Technology.

(Benjamin Busjaeger, Hong Sun and Yuntao Zhou) The Relationship Service in IBM WebSphere Process Server is an infrastructure service that is well integrated with other transformation components to support the development of complex integration solutions. It frees integration developers from needing

(Willie Favero) I don’t usually mention tools announcements but I think this one is significant for a few reasons. First OE is very cool. Optimization Service Center (OSC) and Optimization Expert (OE) share the same interface.

(Craig Mullins) Recently, I received the following question, which I will answer today on this blog posting.

(Alex Osuna, Dale McInnis, Jawahar Lal and Roger Sanders) DB2 customers using IBM N Series storage systems at the back end must take advantage of advanced features of Data ONTAP such as SnapMirror, FlexVol, FlexClone, and RAID-DP to ensure data availability and reliability. These features combined w