473,248 Members | 1,915 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,248 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 14398
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: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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...

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.