(Roman B. Melnyk and Paul C. Zikopoulos) This article is another in a series that introduces some of the key features in DB2 UDB “Stinger,” and includes “work-through” examples that you can use with the open beta today. In this article, we will introduce enhanced savepoint support.

(Howard Fosdick) If you’re like most people, your New Year’s resolution probably involved some pledge to self-improvement. Why not use DBA certification to fulfill that pledge? In today’s tight job market, it just might be the ticket that moves you in front of less committed candidates.

(Amy D. Wohl) Overwhelmed by the volumes of data we’re producing, organizations are looking for new ways to analyze it into useful information. Because of the volumes involved, they need to find techniques to provide as much automation as possible. Both large and established vendors and small s

(Craig Mullins) How do I choose the DB2 server platform (z/OS, Linux, Unix or Windows)? With some applications, we have the choice of selecting between the platforms, but when should I prefer z/OS, Linux, Unix or Windows? Any guidelines to follow? (R)

(Paul C. Zikopoulos and Roman B. Melnyk) DB2 UDB used to have a dependency on a C compiler for the creation of SQL PL procedures. Customers and partners have expressed their interest in eliminating this dependency in their DB2 UDB environments, for the following reasons. First, there is a cost as

(Roger Sanders) If both the server and the client are configured to use the CLIENT authentication type, authentication occurs at the client workstation (if the database is a nonpartitioned database) or at the database partition where the client application is invoked from (if the database is a parti

(Jennifer deJong) Promising the production version later this year, IBM Corp. recently made available the beta version of its DB2 Universal Database, code-named Stinger, which will replace version 8.1. Many of its 200 new features aim to ease database administration and boost performance, but St

(Mika Nikolopoulou) Replication is one way to make your data available where and when you need it. This article explains what replication can do for you, and shows you how to set it up, step by step, using an example from an actual customer site. The author includes hints and tips along the way to h

(Michael A. Ahern) The downloadable files available here are screen captures of DB2 Content Manager version 8.2 installations presented as Viewlets. Demonstrations include Viewlets of installing (AIX and Windows platforms unless otherwise noted) DB2 Enterprise Server Edition version 8.1, WebSphe

(Naga Ayachitula, Andrew Bradfield and JoAnn Brereton) This is an introductory article on programming with IBM DB2 Records Manager. In this article we will walk through a simple exercise of logging in to a Records Manager engine. For the purposes of this article, it is assumed that the Records Manag