Need Info on "UDB"

Sanjay Thakur

Need Info on "UDB"
Hi List,

Today only I joined to this list. I am working as a
DB2 developer since 3-4 yrs.

Since long time I am hearing lot about "UDB". But I
don't have exact idea about it, what exactly it is?
and How it is different from DB2 or is it same as
DB2V6? Some body told me that it is new name for
DB2V6. Is that right?

I will greatly appreciate to LIST members, to provide
me detail information on this matter, and help me to
understand "UDB" better.

Thanks in advance,
Sanjay Thakur

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



Bob Abad

Re: Need Info on "UDB"
(in response to Sanjay Thakur)
Sanjay,

Here's the UDB url for V6 & V7:

http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report#UDBPUBS

Hope this gives you clear picture of UDB in UNIX...



James Campbell

Re: Need Info on "UDB"
(in response to Bob Abad)
Once upon a time MVS (as it was named in those days) had "DB2", and OS/2 had
"DBM" (Data Base Manager). And AS/400 had a relational data base engine
which was just another bit of that operating system.

Then the powers that be decided that as DB2 had such a good brand image,
that as they expanded the scope of OS/2's DBM into Windows and *IX, they
would rename it "DB2". But the two DB2s were totally different internally.
And AS/400 stayed as it was.

Then the powers that be decided that the two DB2s would become one. So,
from V6 onwards, there is just "DB2 Universal Database" or "DB2 UDB" for
short. (The obvious single three letter acronym is not used - for obvious
reasons.) However the code and features of the two still relect their
parentage: sometimes one has things the other doesn't, and sometimes they
just do similar things differently. If you follow Bob's link, you'll notice
that there is a common set of manuals for DB2 UDB for Windows, OS/2 and *IX,
and another set for DB2 UDB for OS/390. (And another DB2 for VSE & VM which
hasn't yet made it to the UDB label.)

And since this was all so wonderfull, they renamed the relational database
engine in AS/400 (or is it now "i/OS"?) as DB2 UDB for AS/400. But, again
it has a totally different parentage.

Since "UDB" does not actually convey any information, most non-IBM people
don't bother including it - just "DB2 for <platform>".

To be fair to them, IBM claim that all these DB2s are now part of one big
happy family and that as time passes they will ensure that the features and
facilites are harmonised as much as possible. So what is available in one
will/should/might be available in all.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Doncaster
+61 3 9843 8442
[login to unmask email]

-----Original Message-----
From: Sanjay Thakur [mailto:[login to unmask email]
Sent: Saturday, December 16, 2000 12:09 PM
To: [login to unmask email]
Subject: [DB2-L] Need Info on "UDB"


Hi List,

Today only I joined to this list. I am working as a
DB2 developer since 3-4 yrs.

Since long time I am hearing lot about "UDB". But I
don't have exact idea about it, what exactly it is?
and How it is different from DB2 or is it same as
DB2V6? Some body told me that it is new name for
DB2V6. Is that right?

I will greatly appreciate to LIST members, to provide
me detail information on this matter, and help me to
understand "UDB" better.

Thanks in advance,
Sanjay Thakur

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/







**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************



Sanjeev (CTS) S

Re: Need Info on "UDB"
(in response to James Campbell)
There were good discussion on the naming of UDB and DB2 after one of the
forwarded mail (by IBM) from Morill John in which IBM requested the DB2
family databases to be called as DB2 UDB for "platform name".James explained
most of the things in this thread but do search in the archive for some more
stuffs on this.
Now a days DB2 is available on most of the platforms. I have also been asked
these kind of questions many times in the place i have worked and many
people never believes when i say I am running DB2 on my NT workstation. I
believe the best thing is download the trial version of DB2 UDB V6/V7 from
IBM site and run it on your NT machine/ or Windows 9* series platforms. You
will find it very new stuffs, easy to learn and deploy.All the
documentations are available and at last the precious(and priceless) DB2-L
list is there for any further doubts. If you have DB2 UDB for OS/390 , also
try connecting to that from your NT DB2(personal edition). I have done most
of the experiements including running replication as well by doing this.

HTH

Regards
Sanjeev

> -----Original Message-----
> From: Sanjay Thakur [SMTP:[login to unmask email]
> Sent: Saturday, December 16, 2000 6:39 AM
> To: [login to unmask email]
> Subject: Need Info on "UDB"
>
> Hi List,
>
> Today only I joined to this list. I am working as a
> DB2 developer since 3-4 yrs.
>
> Since long time I am hearing lot about "UDB". But I
> don't have exact idea about it, what exactly it is?
> and How it is different from DB2 or is it same as
> DB2V6? Some body told me that it is new name for
> DB2V6. Is that right?
>
> I will greatly appreciate to LIST members, to provide
> me detail information on this matter, and help me to
> understand "UDB" better.
>
> Thanks in advance,
> Sanjay Thakur
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/
>
>
>
>
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------



Sanjay Thakur

Re: Need Info on "UDB"
(in response to Sanjeev (CTS) S)
I am really glad to get all these information on
"UDB". These helped me to clear all my doubts.

Thanks lot to James, Sanjeev and Abad Bob for helping
me to understand "UDB' better and contributing their
suggestions and valuable information to me.

Regards,
Sanjay Thakur

--- "S, Sanjeev (CTS)" <[login to unmask email]>
wrote:
> There were good discussion on the naming of UDB and
> DB2 after one of the
> forwarded mail (by IBM) from Morill John in which
> IBM requested the DB2
> family databases to be called as DB2 UDB for
> "platform name".James explained
> most of the things in this thread but do search in
> the archive for some more
> stuffs on this.
> Now a days DB2 is available on most of the
> platforms. I have also been asked
> these kind of questions many times in the place i
> have worked and many
> people never believes when i say I am running DB2 on
> my NT workstation. I
> believe the best thing is download the trial version
> of DB2 UDB V6/V7 from
> IBM site and run it on your NT machine/ or Windows
> 9* series platforms. You
> will find it very new stuffs, easy to learn and
> deploy.All the
> documentations are available and at last the
> precious(and priceless) DB2-L
> list is there for any further doubts. If you have
> DB2 UDB for OS/390 , also
> try connecting to that from your NT DB2(personal
> edition). I have done most
> of the experiements including running replication as
> well by doing this.
>
> HTH
>
> Regards
> Sanjeev
>
> > -----Original Message-----
> > From: Sanjay Thakur [SMTP:[login to unmask email]
> > Sent: Saturday, December 16, 2000 6:39 AM
> > To: [login to unmask email]
> > Subject: Need Info on "UDB"
> >
> > Hi List,
> >
> > Today only I joined to this list. I am working as
> a
> > DB2 developer since 3-4 yrs.
> >
> > Since long time I am hearing lot about "UDB". But
> I
> > don't have exact idea about it, what exactly it
> is?
> > and How it is different from DB2 or is it same as
> > DB2V6? Some body told me that it is new name for
> > DB2V6. Is that right?
> >
> > I will greatly appreciate to LIST members, to
> provide
> > me detail information on this matter, and help me
> to
> > understand "UDB" better.
> >
> > Thanks in advance,
> > Sanjay Thakur
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Shopping - Thousands of Stores. Millions of
> Products.
> > http://shopping.yahoo.com/
> >
> >
> > To change your subscription options or to cancel
> your subscription visit
> > the DB2-L webpage at http://www.ryci.com/db2-l.
> The owners of the list can
> >
>
-----------------------------------------------------------------------------------------------------------------------------------------
>
-----------------------------------------------------------------------------------------------------------------------------------------
> This e-mail and any files transmitted with it are
> for the sole use
> of the intended recipient(s) and may contain
> confidential and privileged information.
> If you are not the intended recipient, please
> contact the sender by reply e-mail and
> destroy all copies of the original message. Any
> unauthorised review, use, disclosure,
> dissemination, forwarding, printing or copying of
> this email or any action taken in
> reliance on this e-mail is strictly prohibited and
> may be unlawful.
>
> Visit us at http://www.cognizant.com
>
----------------------------------------------------------------------------------------------------------------------------------------
>
----------------------------------------------------------------------------------------------------------------------------------------
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



Mark Harmon

Re: Need Info on "UDB"
(in response to Sanjay Thakur)
James,

Thanks for the excellent history lesson.