(Paul Zikopoulos) In my latest articles, I’ve been writing about the IBM Rational Data Architect (Rational DA) integrated development environment (IDE), a tool that’s specifically designed for those involved in data server design and schema evolution. So far, I’ve shown you how to add a database con

The most important point in any database software is its compliance to ACID properties. These are set of properties that guarantees that a transaction ( all the steps right from start to end e.g sign in to sign out) executed in orderly and reliable manner. Say for an example if you have to transfer

(Willie Favero) Today’s post is a short heads-up for those of you that have just moved to DB2 9 for z/OS and also use table space compression (did you notice I have to start identifying whether I’m talking about table space or index compression now). If you are satisfied with your compression’s dict

(Willie Favero) Back on March 23, 2007, before DB2 9 officially went GA, I had a short post that discussed CLONE tables in DB2 9 for z/OS. I didn’t want to go in to a lot of detail at that time because DB2 9 wasn’t available yet. However, now that it has been out for a few months, I would […]

(Philip Nelson) When you start digging into the internals of anything you come up with some strange findings. Here is one I came across recently. I discovered this through my work with the DB2 adapter / driver for Ruby on Rails, and am indebted to Alex Pitigoi and Antonio Cangiano in the IBM labs fo

(Hannah Smalltree) When a major hospital network in South Korea wanted to electronically consolidate all patient data — much of it handwritten — it faced some major hurdles. (R)

(Chris C. Gruber) Integrate your Microsoft Office 2007 documents into your enterprise and Internet applications more easily than ever before with DB2 9. Review older methods of data interchange with MS Office documents, and learn how MS Office 2007 offers better data interchange. This article discus

(Willie Favero) It’s raining this dreary Saturday morning in Houston so I’ve decided to post a revision to one of my previous post that I made this week. Because I am now “working”, I’m hoping this gets me out of hanging pictures today. (Isn’t it kind of strange that both of my recent posts on multi

(Leons Petrazickis) When creating a table in a Rails migration, you have to specify data types using platform-agnostic names.

(Willie Favero) It’s 6:30 AM Friday and I’m back at Dallas’s Love Field playing airline roulette. Flights are still messed up this morning because of crews arriving late last night and planes being in the wrong place after the thunderstorm finally ended (or has it really ended). I am hoping to make