UDB2 software - IBM AS400

This is a discussion on UDB2 software - IBM AS400 ; 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 ...

+ Reply to Thread
Results 1 to 6 of 6

Thread: UDB2 software

  1. UDB2 software

    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

  2. Re: UDB2 software

    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

  3. Re: UDB2 software

    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

  4. Re: UDB2 software

    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.

  5. Re: UDB2 software

    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

  6. Re: UDB2 software

    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

+ Reply to Thread