Friday, September 29, 2006

DB2 & UDB ????!!!????

Recently happenned to come across a really valuable blog site . Many might have known Craig Mullins and his expertise on database, DB2. I felt it is late I knew of this site.

Iam grabbing time then n there to go through all the possible posts he has made. One of which I read recently is on nomenclature on DB2. My mailbox is flooded with job notifications from consultants & HR professionals saying "both DB2 & UDB mandatory skills". I would like to stress DB2 or UDB is one and same. DB2 expands to DataBase 2 and UDB expands to Universal DataBase. So, DB2 & UDB are always together. IBM named its database as "DB2 UDB". But, there are variants of DB2 depending upon operating systems.

OF the DB2 family, DB2 base code (that are database functionalities) is one and same for all these variants (just like Lx or Lxi or Vxi of Maruti Cars, they all have same engine specs). The OS interface layer is customized depending on the OS and to leverage OS features. But, even among professionals, it is common to refer DB2 on Windows or Linux or Unix as "UDB" which really frustrates me , at times. Even on IBM's Zseries machines (S/390 too), the DB2 is UDB !

So, it is either DB2 UDB for LUW or DB2 UDB for Z/oS !!

3 comments:

Hell's Angel said...

the best part of this post is comparison with maruti cars...i loved tht..

Karthik Srinivasan said...

konjam java saniyankum ipdi edhaachum sites irundhaa sollungnaa!!! ;-)

Balachandran C said...

@ KSR, there must be many sites for Java that need not special mention. DB2 is less commercial database product than Oracle that I was surprised to see an OS specific blog.