(Scott Olson and Joshua Steffan) When tuning a database environment such as DB2, the Database Administrator (DBA) often needs to look at many things on many different levels before determining a viable approach to resolving the issue at hand. Is the application SQL written properly? Are the database

(Robert Bestgen and Denise Voy Tompkin) The newly redesigned query engine in DB2 Universal Database (UDB) for iSeries is not your father’s query engine. While both the new SQL Query Engine (SQE) and the existing Classic Query Engine (CQE) can handle your queries from start to finish, the redesigned

(Roger Sanders) This tutorial introduces you to CLI/ODBC programming and walks you through the basic steps used to construct a CLI/ODBC application. It also introduces you to the process to convert one or more high-level programming language source code files containing CLI/ODBC function calls into

(Jarek Miszczyk) The free href=”http://www-919.ibm.com/servers/eserver/iseries/developer/db2/oraclemtk.html”>IBM DB2 Migration Toolkit for iSeries (MTK) can significantly reduce the effort required to migrate an Oracle database solution to the iSeries and thus shorten the time to market for your app

(Bob Swart) This article uses Delphi 8 for .NET and the data-aware controls from the Visual Component Library to bind to DB2 UDB tables.

(Drew Bradstock) In this tutorial you’ll learn advanced programming skills for writing applications that interface with the DB2 Universal Database. Topics include dynamic and static SQL, use of UDTs, compound SQL, concurrency considerations, distributed units of work, parameter markers, Unicode, and

(Julian Stuhler) As I’m sure everyone reading this will know by now, DB2 for z/OS Version 8 (hereafter referred to simply as “V8”) has finally become available on 26th March 2004. V8 is a very significant release of DB2 – not only in terms of the new functionality delivered to the user, but also in

(Craig Mullins) Could you please explain the difference between a package and a plan, the process of precompilation, compilation and running a COBOL DB2 program as well as a COBOL CICS DB2 program? (R)

(Clint Boulton) After months of unveiling features by the piece for its next-generation database, IBM is planning to launch the finished product in late April or early May, according to a source familiar with the company’s plans.

(Susan Lawson) A trigger is a set of actions that will be executed when a defined event occurs. These are known as active triggers. The triggering events can be the following SQL statements: –INSERT –UPDATE –DELETE (R)