ga wrote:
> can anyone point me to some references regarding UDB2? Is that
> strictly something that runs on a PC client? Or do I need a piece of
> software on the as/400? Is it "free" or is it for a charge? I see in
> websphere development studio I have a cd that says DB2 Unviersal
> Database Express Edition, Version 8.2 CPU Option.
>
> Apparently we are getting a CRM package soon that utilizes DB2 on a
> client, but is this what I install that from? Is there anything I need
> on the as/400 side??
>
> Definitely a novice in this area. Appreciate suggestions, hints,
> advice, etc.
>

UDB (Universal Database) was added to DB2 product names some years ago,
but has since been dropped. For IBM i (aka AS/400, iSeries, System i),
DB2 is integrated into the OS. This link may help:

www.ibm.com/systems/i/software/db2/db2faq.html

--
Karl Hanson

Karl,

Thanks for the link

ga

Karl Hanson wrote:

>ga wrote:
>> can anyone point me to some references regarding UDB2? Is that
>> strictly something that runs on a PC client? Or do I need a piece of
>> software on the as/400? Is it "free" or is it for a charge? I see in
>> websphere development studio I have a cd that says DB2 Unviersal
>> Database Express Edition, Version 8.2 CPU Option.
>>
>> Apparently we are getting a CRM package soon that utilizes DB2 on a
>> client, but is this what I install that from? Is there anything I need
>> on the as/400 side??
>>
>> Definitely a novice in this area. Appreciate suggestions, hints,
>> advice, etc.
>>
>
>UDB (Universal Database) was added to DB2 product names some years ago,
>but has since been dropped. For IBM i (aka AS/400, iSeries, System i),
>DB2 is integrated into the OS. This link may help:
>
>www.ibm.com/systems/i/software/db2/db2faq.html

ga
nospam@nospam.fmctc.com

ga wrote:
> can anyone point me to some references regarding UDB2? Is that
> strictly something that runs on a PC client? Or do I need a piece of
> software on the as/400? Is it "free" or is it for a charge? I see in
> websphere development studio I have a cd that says DB2 Unviersal
> Database Express Edition, Version 8.2 CPU Option.
>
> Apparently we are getting a CRM package soon that utilizes DB2 on a
> client, but is this what I install that from? Is there anything I need
> on the as/400 side??
>
> Definitely a novice in this area. Appreciate suggestions, hints,
> advice, etc.
>
> thanks,
> ga
>
> ga
> nospam@nospam.fmctc.com

http://www.ibm.com/developerworks/db...db2/index.html

I'm not sure if the "UDB" tag has been dropped from its title as another
poster suggested but the "universal" part was to suggest it run on
multiple platforms. Basically all Windows and Linux environments as well
as the pseries and I think solaris. I believe the big metal could run it
under Linux as well but they also have their specialised z/OS version of
DB2 much the same as the ISeries has its own version of DB2.

When IBM publishes performance figures for DB2 it is invariably the P
Series Linux version that is tested from what I can tell.

That said, they are all very compatible (but not identical) so the SQL
structure is usually consistent across the two that I play with - the
ISeries and UDB. This is the reason it is probably provided in the WDS
package - as a means to allow off-ISeries development.

You should also note that the Apache Derby database is very compatible
as it was donated to Apache from IBM. It is also a LOT more lightweight.
The problem you get there is that the Functions, Stored Procedures and I
think Triggers are not compatible as these are Java only at this stage.
There is some mention that they will allow SQL coded versions eventually.

The UDB that came with WDS is probably pretty old and potentially less
compatible. You should look to download the Express-C edition which runs
like the clappers but has a 2 core processor and 2GB limit imposed.

http://www-01.ibm.com/software/data/db2/express/

Also if you download Express look for the development environment. It
used to be called "DB2 Developer Workbench". This works great with the
ISeries. It is now called IBM Data Studio but I haven't tried this one
yet as the older DWB was already great.


OK that covers DB2. Now finally, back to your original request,
basically it will depend on the CRM vendor which product they prefer. I
imagine it would have a centralised database component so you are going
to be told to buy a UDB environment or that you can use the ISeries.
Despite their common "DB2" naming they are very diferrent beasts
implementation wise. If the origin of the product is a group of UDB
programmers then they will most likely not be inclined to go the ISeries
direction. They might go P Series if you got one.

One thing though - I would not be too thrilled about running any DB2
database itself on the everyday client environments. It is fine for the
clients to read data off a server but for a client environment running
the DB2 server is not a light background processes. Maybe DerbyDB could
do it but a local client installed DB2/UDB instance for a CRM app would
seem a bit of an overkill. Just some thoughts if this is the intended
approach rather than running a centralised DB2 server.

Rj.

DBDriver wrote:
>
> http://www.ibm.com/developerworks/db...db2/index.html
>
> I'm not sure if the "UDB" tag has been dropped from its title as
> another poster suggested but the "universal" part was to suggest
> it run on multiple platforms. Basically all Windows and Linux
> environments as well as the pseries and I think solaris.
> I believe the big metal could run it under Linux as well but they
> also have their specialised z/OS version of DB2 much the same as
> the ISeries has its own version of DB2.
> <>
>
> The UDB that came with WDS is probably pretty old and potentially
> less compatible. You should look to download the Express-C edition
> which runs like the clappers but has a 2 core processor
> and 2GB limit imposed.
> http://www-01.ibm.com/software/data/db2/express/
> <>

The Universal Database, or UDB for short, was dropped. FWiW it
should be telling, that when visiting the referenced links and even
www.ibm.com/db2, searching the pages for the token "UDB" will not find
any occurrences. Similarly telling, that older links like
www.ibm.com/software/data/db2/udb are now redirected to links that do
not have the token UDB, neither in the URL nor the page. For example
with the above link being redirected to www.ibm.com/software/data/db2/9/
which shows the current name as DB2 for Linux UNIX and Windows.
Typically the product is referred to generically as DB2 for LUW or even
just DB2 LUW, whereas previously the name was DB2 Universal Database for
Linux UNIX and Windows, and having a similarly shortened name DB2 UDB
for LUW.

DB2 LUW has several editions including the no-cost Express-C. I am
not sure if the "Express-C" equates with the "Express Edition, ... CPU
option" mentioned by the OP. As I understood it, the "-C" was meant to
imply "Community" version of the Express Edition. With regard to the
no-cost DB2 Express-C and its 2-core & 2GB limits [to be clear, that is
a memory limit, not a limit to database sizes; IIRC both limits are
doubled with a support contract\subscription in place], the equivalent
entry level server product that is available both for a cost and without
those limits, is called DB2 Express [w/out the "-C"]:
www.ibm.com/software/data/db2/9/

Regards, Chuck

DBDriver wrote:
> ga wrote:
>> can anyone point me to some references regarding UDB2? Is that
>> strictly something that runs on a PC client? Or do I need a piece of
>> software on the as/400? Is it "free" or is it for a charge? I see in
>> websphere development studio I have a cd that says DB2 Unviersal
>> Database Express Edition, Version 8.2 CPU Option.
>> Apparently we are getting a CRM package soon that utilizes DB2 on a
>> client, but is this what I install that from? Is there anything I need
>> on the as/400 side??
>>
>> Definitely a novice in this area. Appreciate suggestions, hints,
>> advice, etc.
>>
>> thanks,
>> ga
>>
>> ga
>> nospam@nospam.fmctc.com
>
> http://www.ibm.com/developerworks/db...db2/index.html
>
> I'm not sure if the "UDB" tag has been dropped from its title as another
> poster suggested but the "universal" part was to suggest it run on
> multiple platforms. Basically all Windows and Linux environments as well
> as the pseries and I think solaris. I believe the big metal could run it
> under Linux as well but they also have their specialised z/OS version of
> DB2 much the same as the ISeries has its own version of DB2.
>


Prior to UDB being dropped, the name designated a set of supported SQL
functions rather than a common code base running on multiple platforms.
In addition to DB2 UDB for LUW (Linux, Unix, and Windows), there was DB2
UDB for iSeries and DB2 UDB for z/OS. Although versions of DB2 UDB for
LUW could be run in Linux environments of i and z systems (eg iSeries
Linux partition), DB2 UDB for iSeries was the RDBMS integrated into
OS/400 (aka i5/OS) - the same native DB2 that existed before and after
"UDB" was part of the name. As Chuck mentioned, "UDB" has since been
dropped from product names, including LUW. Here are a couple example
links with "Universal Database" in iSeries and z/OS product names.

http://publib.boulder.ibm.com/iserie...f/rzahfms1.htm
http://www-01.ibm.com/software/data/.../db2zosv8.html

--
Karl Hanson