(Whei-Jen Chen) IBM DB2 Universal Database Version 8.2 is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements of information management customers. This redbook is an update of DB2 UDB Exploitation of the Windows Environment (S

(Craig Mullins) TableA is a high transaction table. TableB is essentially a copy of TableA with indexes for reporting. I want to create an insert/update trigger on TableA to replicate the change to TableB. I’m worried about performance. Mainly, will TableA be locked up until the commit on TableB

(Nagraj Alur) This redbook provides an overview of DB2 Information Integrator key performance drivers, best practices to achieve optimal performance, and guidelines on monitoring a DB2 Information Integrator environment for capacity planning and problem diagnosis and resolution. (pdf)

(Craig S. Mullins) DB2 is a complex piece of system software that can be very intimidating for users to learn and master. There are a lot of details, parameter, syntax choices, and manuals that need to be understood. Difficulties can arise for a number of different reasons. This hitchhiker’s gui

This articles explains how to determine the Network Address and Network Port number for the following data providers with an AS/400 over TCP/IP: Microsoft OLE DB Provider for AS/400 and VSAMMicrosoft OLE DB Provider for DB2Microsoft ODBC Driver for DB2.

(Gwyneth Evans) If you are migrating from a 32-bit DB2 instance to a 64-bit one, deploying 32-bit applications to 64-bit platforms, or simply want to ensure that you can do so easily later, then this article is for you. We outline DB2 Universal Database’s (DB2 UDB) 32-bit and 64-bit application

This technote describes how to access and move tables in Informix Dynamic Server (IDS) by using the capabilities of DB2 Data Federation.

(Craig Mullins) I am new to DB2. We are migrating an Oracle database to DB2. In this conversion, I have to convert Oracle SQL to DB2 SQL. (R)

(Jianing Fan) This is the second of a two-part series on tuning Informix SQL. Part 1 introduced guidelines for SQL query tuning for Informix, looked at factors you need to consider when tuning SQL queries, and examined some real life tuning examples gathered from the author’s experience. Now the

This technote describes how to create and update a DB2 64-Bit instance.