(Antonio Cangiano) The IBM API development team has released version 1.0 of the ibm_db gem, which includes both the Ruby driver, and the Rails adapter, for IBMs databases. This is a very important milestone for the DB2 on Rails community, and it ships with quite a few goodies.

(Craig Mullins) DB2 allows you to add and subtract DATE, TIME, and TIMESTAMP columns. In addition, you can add date and time durations to, or subtract them from, date and time columns. But use date and time arithmetic with care. If you do not understand the capabilities and features of date and time

(Stuart Mackenzie) IBM U2 SystemBuilder Extensible Architecture for UniData and Universe (SB/XA) 6.0.0 introduces an entirely new application architecture for SystemBuilder applications. One of the features provided by the changes in the architecture is the ability to modify the presentation of your

(Robert Catterall) Some DB2 for z/OS questions first asked years ago came to be moot due to advances in product technology and functionality. It used to be, for example, that people wanted to know how to reduce index page lock contention, but that was before type 2 indexes (delivered in DB2 V4) elim

(Willie Favero) RSU0810 is now available. This addendum is based on the CST 3rd quarter 2008 recommendation (RSU0809 – all service through end of June 2008 not already marked RSU and PE resolution/HIPER/Security/Integrity/Pervasive PTFs and their associated requisites and supersedesthrough August 20

(Tom Miller and Emily Zhang) The Unified Debugger in DB2, combined with Data Studio Developer, together provide a great toolset for anyone creating SQL native or external stored procedures as well as Java stored procedures. This article provides important background information on the Unified Debugg

(Conor O’Mahony) As you saw in my previous post, IBM DB2 has spectacular performance numbers when benchmarking with XML data. As a reminder, DB2 performed 48.5 million transactions from 200 concurrent users over a two hour period on a server 4 CPUs, where each CPU had 6 cores. Admittedly, this is a

(Farzad Farahbod and Ajay Aggrwal) IBM’s support for the Microsoft .NET Framework 3.5 Windows Workflow Foundation (WF) allows users to create Windows workflow applications that map directly to any IBM data server relational object. In this article, you’ll see how easy it is to create a Windows workf

(Andrew Ford) Last month we took a look at Data Partitioning, an Informix Dynamic Server feature that gives you the ability to break your larger tables into seperate partitions. We saw how this feature can be used to quickly detach and drop older data from your tables and attach new partitions to st

(Jennifer Kavur) Enterprise management solutions provider BMC Software Inc. has launched new software that optimizes data management performance.