(Alex Woodie) IBM is nearing completion of new software that will enable DB2/400 to power the open source MySQL database, according to industry sources. When complete, the new software will enable organizations that run PHP applications running on MySQL on i OS to access data stored in DB2/400, the

(Willie Favero) That’s right! We now have a certification test for DB2 System Administrators. It’s Test 737: DB2 9 System Administrator for z/OS Exam. When achieving a passing grade for Test 737, you will receive an IBM Certified DB2 9 System Administrator for z/OS certification.

(Troy Coleman) Have you ever considered the performance impact (high CPU) of having a few short-running SQL statements out of a larger number of statements in a package? What if you have a few short-running SQL statements spread across a larger number of packages executed within a transaction?

(Robert Catterall) I’m in Warsaw, Poland, this week for the 2008 International DB2 Users Group European Conference. It’s been a good first day. This is my first time in Poland, and I have to say that the level of human energy in Warsaw is quite impressive. Construction cranes reach into the sky all

(Jeff Berger and Paolo Bruni) This IBM Redpaper provides best practices and I/O-related performance considerations for backup and recovery using DB2 9 for z/OS. It describes some guidelines for DB2 for z/OS backup and recovery, then it discusses performance considerations that may be used to predict

In Informix, free pages in an extent are tracked via bitmap pages. Each bitmap entry describes the fullness of one page in the extent. In this article, well explore the structure and use of bit-map pages.

(Bill Arledge) DB2 9 has been available since March 2007. You may be taking a closer look and evaluating those features that provide the most potential for benefit. DB2 9 is a significant new release that introduces new capabilities that cross the entire spectrum of DB2 implementation, including new

(Willie Favero) I arrived in Warsaw Friday evening and didn’t really figure out all the connectivity stuff until this morning. So yes, I do realize that this Friday post is occurring on a Sunday.

(Brian Byrne, Greg Imirzian and Janet Wall) This is the second of two articles that focus on the use of IBM Industry Models and ILOG business rule management system (BRMS) to structure the analysis, design, and deployment of business rules. The previous article in this series referenced the IBM Indu

(Michael Sansoterra) Released in August 2008, SQL Server 2008 is the latest incarnation of Microsoft’s flagship database platform. While there are some cool new features for developers, there is one for DB2 developers that deserves special mention: the new Transact SQL (T-SQL) MERGE statement. MERGE