(Julian Stuhler) Welcome to the fourth and final part of our exploration of the new features in Version 8 of DB2 UDB for Linux, UNIX and Windows. This time round, we’re going to look at some of the many SQL enhancements that can be found in the new release. DB2 UDB for Linux, UNIX and Windows has

(Marina Greenstein, Art Sammartino and Knut Stolze) Migrating to DB2 from another RDBMS? Here are some routines that will help you easily migrate some frequently-used functionality in other database products.

(Vanja Josifovski, Sabine Massmann, and Felix Naumann) The XML Wrapper is a new feature of the federated database capabilities of DB2/UDB v8. It enables users and applications to issue SQL queries against XML data from a variety of sources, including files and web services. The XML Wrapper assumes h

Are you an ISV or IBM Business Partner wanting to establish a mobile solution in your enterprise? Are you interested in IBM’s mobile technology with DB2 Everyplace? If so, this 3-day workshop is for you!

(Dwaine Snow and Raul F. Chong) Ever wonder what all those DB2 processes actually do? This article describes the processes that DB2 UDB uses on Linux, UNIX and Windows, discusses why you might need to understand these processes, and details their functions.

Many DB2 for z/OS DBAs, developers, and systems programmers are well aware of what you can alter with respect to the definition of a database object, and, just as important, what you cannot alter. At times, it may seem as though you can alter just about everything EXCEPT what you really want to chan

(Barry Devlin, Bill O’Connell, Pat Selinger and Hamid Pirahesh) Time and colums in this column, I have written about leading edge data warehousing using DB2 UDB and also about IBM’s recently-introduced product, DB2 Information Integrator, that features, among other things, IBM’s data federation capa

(Raul F. Chong) If you are new to IBM DB2 Universal Database(UDB) for Linux, UNIX and Windows, or are preparing to take the certification exams, this article may save you some time trying to grasp the main concepts about the DB2 environment. It is commonly said that a picture is worth a thousand

This tutorial will introduce you to the concept of data consistency and to the various mechanisms that are used by DB2 Universal Database to maintain database consistency in both single- and multi-user environments. In this tutorial, you will learn: –What data consistency is –What transactions

(Jalud Abdulmenan and Raul F. Chong) This is the fifth article in a series discussing connectivity scenarios involving DB2 UDB for Linux, UNIX and Windows version 8, DB2 UDB for iSeries 5.2 and DB2 UDB for z/OS V8. The focus of this article is on workstation application development connectivity for