Configuring ADO.NET data adapters to call DB2 UDB stored procedures was a complex task prior to the introduction of the DB2 Stinger technology! This tutorial walks you through the steps required to build an application that uses SQL stored procedures to select, insert, update, and delete rows from d

(Victor Alvarez) With the latest release of DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows, IBM provides .NET developers with a credible alternative to SQL Server. Traditionally, developers working with .NET have resorted to Microsoft SQL Server as the database of choice.

(Craig S. Mullins) This complimentary 6-part eCourse will provide you with expert tips and techniques for optimizing DB2 for z/OS catalog usage. The Lesson Plan includes: Lesson 1: Use RUNSTATS on the Catalog Lesson 2: REORG the DB2 Catalog Lesson 3: More Catalog REORG Scenarios Lesson 4: C

(Serge Rielau) This article describes an API that allows for transparent tracing of SQL procedures as well as explicit tracing of non-SQL procedures in DB2 Universal Database (UDB) V8.2 for LUW. An example SQL interface to this API is provided, as well.

Microsoft partner Extreme Logic offers a series of demos and presentations highlighting the integration between SQL Server 2000 and IBM DB2, with a focus on how SQL Server 2000 can add value to an existing IBM DB2 environment, be it on the mainframe, AS/400, UNIX, or Microsoft Windows operating syst

(Mark Chiang and Daniel Debrunner) Some of the functionality described in the IBM DB2 Universal Database (DB2 UDB) SQL Reference for Cross-Platform Development Version 1.1 is not supported by Derby. This article lists these differences. This comparison was developed by reviewing the DB2 UDB SQL

(Paul Zikopoulos, Roman Melnyk and Leon Katsnelson) DB2 Connect is IBM middleware for connectivity from distributed systems to host- and mainframe-based DB2 systems. This article introduces DB2 Connect and discusses the different editions and pricing models to help you decide which implementation is

(David Worthington) After a nearly two-year hiatus, IBM has updated its DB2 database software with capabilities borrowed from its autonomic computing portfolio. DB2 Universal Database (DB2 8.2), formerly code-named Stinger, automatically self manages and self tunes data without human intervention.

(Howard Fosdick) IBM releases new versions of DB2 every couple of years, so I get a lot of questions about how new DB2 versions should influence a DBA’s certification plan. Does it make more sense to certify with version 7 or version 8? If you’ve already passed the exam DB2 UDB v.7.1 Family Fundamen

(Robert Westervelt) IBM is launching the next version of its DB2 Universal Database, code-named Stinger, touting new autonomic features and .NET developer tools. Stinger will be widely available Sept. 17. (R)