473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DB2 versus UDB

I have always been confused abuot the terminology. What is the
difference between DB2 and UDB? Are they one and the same? Is one a
subset of the other?

Thanks in advance.
-Dal Mon

Jul 10 '07 #1
3 14409
Dal Mon wrote:
I have always been confused abuot the terminology. What is the
difference between DB2 and UDB? Are they one and the same? Is one a
subset of the other?
There never was a UDB product.
"Universal Database" was a "property" added to versions of DB2 that had
a certain extensibility options (e.g. LOBs, UDF, distinct types)
(Informix calls it "Universal Server").
DB2 UDB V5 for LUW was the first to "earn" that label.
Therefore many people chose to shorten DB2 UDF for LUW as UDB, implying
that "DB2" is DB2 for zOS.
Over the years DB2 for zOS and DB2 for iSeries also got the UDB label.
Since all major vendors today have these extensibility options, the
label as largely lost its meaning.
DB2 9 (on either LUW or zOS) does not carry the UDB label anymore.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jul 10 '07 #2
Serge Rielau wrote:
Dal Mon wrote:
>I have always been confused abuot the terminology. What is the
difference between DB2 and UDB? Are they one and the same? Is one a
subset of the other?
There never was a UDB product.
"Universal Database" was a "property" added to versions of DB2 that had
a certain extensibility options (e.g. LOBs, UDF, distinct types)
(Informix calls it "Universal Server").
DB2 UDB V5 for LUW was the first to "earn" that label.
Therefore many people chose to shorten DB2 UDF for LUW as UDB, implying
that "DB2" is DB2 for zOS.
Over the years DB2 for zOS and DB2 for iSeries also got the UDB label.
Since all major vendors today have these extensibility options, the
label as largely lost its meaning.
DB2 9 (on either LUW or zOS) does not carry the UDB label anymore.
DB2 for i5/OS (iSeries or System i) also no longer uses the UDB label.

www.ibm.com/servers/eserver/iseries/db2/

--
Karl Hanson
Jul 10 '07 #3
"Dal Mon" <da******@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...
>I have always been confused abuot the terminology. What is the
difference between DB2 and UDB? Are they one and the same? Is one a
subset of the other?

Thanks in advance.
-Dal Mon
This was basically a marketing problem, in that IBM had the following
relational products at one time:

DB2 for MVS
SQL/DS (for VM)
SQL/400 (for AS/400)
OS/2 Database Manager (OS/2) which latter became DB2/2 and then DB2/6000 for
AIX

Oracle always was able to say that they had a single code base for all
platforms (although some of the versions don't work very well on certain
platforms).

So IBM came up with the UDB label for DB2 Linux, Unix, and Windows (and OS/2
up to V7). Then DB2 for z/OS and DB2 for iSeries added the UDB label when
they reached a certain level of compatibility with DB2 for Linux, UNIX and
Windows. This was supposed to be the big merge when all the features where
available on all platforms and the SQL was completely compatible (or 99.9 %
compatible) and they were all called UDB.

The problem is that most corporate customers that had DB2 on the mainframe
and also DB2 LUW used the UDB label to refer the DB2 for LUW product (as
opposed to the mainframe DB2) and the UDB nickname stuck to the LUW product
before the z/OS version had a chance to adopt the UDB name. As already
mentioned, the UDB name is being dropped on all platforms.

You can blame the IBM marketing people for this fiasco, but ultimately it
may be the customer's fault because they are the ones who fall for marketing
BS, such as buying a database based on features that they will never use (or
maybe never should use) or running on platforms they will never use.
Jul 11 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Dieter Vanderelst | last post by:
Dear all, I'm currently comparing Python versus Perl to use in a project that involved a lot of text processing. I'm trying to determine what the most efficient language would be for our...
33
by: Joshua D. Drake | last post by:
Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake
2
by: Andrew Robinson | last post by:
I need to create a shared static field for use within a number of different classes. Which one should I be using or are they all really the same thing? public class Widget { private Widget() {}...
2
by: Jon Lapham | last post by:
I have a table that stores TEXT information. I need query this table to find *exact* matches to the TEXT... no regular expressions, no LIKE queries, etc. The TEXT could be from 1 to 10000+...
135
by: Xah Lee | last post by:
Tabs versus Spaces in Source Code Xah Lee, 2006-05-13 In coding a computer program, there's often the choices of tabs or spaces for code indentation. There is a large amount of confusion about...
1
by: johnpa60 | last post by:
Hello Anyone here has seen any materials on comparing DB2 CM versus Domino Doc Server? Can you please point me? If any of you have worked on both products, can you please spend few minutes...
42
by: John Doty | last post by:
I realized that I have a little job on the table that is a fine test of the Python versus Standard Forth code availability and reusability issue. Note that I have little experience with either...
13
by: blangela | last post by:
I have decided (see earlier post) to paste my Word doc here so that it will be simpler for people to provide feedback (by directly inserting their comments in the post). I will post it in 3 parts...
2
by: John LaRusic | last post by:
Hi all, I'm fairly new to the world of schemas, but I have a question that I hope someone can help answer for me. I'm curious as to what the difference is between an element and a complexType?...
4
by: aj | last post by:
DB2 8.2 LUW FP14 Is there any real difference between select blahblahblah... where blah IN (select blah......) versus select blahblahblah... where blah = ANY (select blah.....) versus select...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.