(Erika Morphy) The announcement that SuSE Linux and IBM are establishing a joint Software Integration Center at IBM’s Toronto Lab in order to develop deeper integration between DB2 Universal Database and SuSE Linux technology was hardly unexpected, given the relationship between the two companies.

(Peter Backlund) Triggers are an important tool for achieving better data quality. They can be found in other RDBMSs and have been available for a long time in DB2 for Linux, UNIX, Windows. For DB2 for z/OS and OS/390 triggers were added in Version 6. A trigger is tightly coupled to a table and

(Gene Thomas) After migrating your High Availability database environment from IBM DB2 Universal Database Enterprise Edition Version 7.2 (DB2 UDB EE V7.2) to IBM DB2 Universal Database Enterprise Server Edition Version 8.1 (DB2 UDB ESE V8.1), you must also perform some DB2 instance-level configurati

This TechNote describes how to configure a Macromedia ColdFusion MX JDBC data source to connect to DB2 using the DB2 Universal Database driver. There are several JDBC Type IV drivers that are provided with ColdFusion MX Server Enterprise Edition and ColdFusion MX for J2EE. DB2 Universal Database

The IBM DB2 Universal Database has become one of the leading relational database management systems for installations that require a high-performance, scaleable platform for running business-critical data warehouse and OLTP applications in a UNIX environment. Its success is based on the strengt

This article explains how defining tablespaces with Locksize Row can impact your DB2 implementation. Find out about several different responses to this request for help in determing the best set of options to use with DB2.

(Roger Sanders) How to change your instance and database parameters for the best Performance effect. If you read the first installment of this Distribued DBA column in the Quarter 3, 2003 issue, you know that database performance problems typically arise from one of the following factors: –Sy

(Dave Hauser) Trying to get around the 255-byte index key limit without sacrificing uniqueness? Triggers just might save the day. If you’ve ever had to adapt schemas from other platforms — such as DB2 Universal Database (DB2 UDB) for NT — to DB2 UDB for z/OS and OS/390 you’ve probably bumped up a

This article provides a sample SQL script for creating a linked server to DB2 using sp_addlinkedserver, and issues a few queries to illustrate the Distributed Query Processing (DQP) using DB2OLEDB, the Microsoft OLE DB provider for DB2. Please refer to the following article in the Microsoft Knowledg

Whether you are flying your air-car through Cairo trying to pick up different colored balls faster than your opponent can, or racing a ski mobile over picturesque snowscapes, vying for video game dominance can be tough. Still, it’s nowhere near as intense as the rivalry among the video game companie