Results 1 to 5 of 5

Thread: db2 ojn OS/400

  1. #1
    Join Date
    Mar 2004
    Posts
    448

    Unanswered: db2 ojn OS/400

    Is db2 on AS/400 is same as db2 on S/390.
    Very ambigious question, but we have an AS/400 and I think the
    db2 already comes with OS/400, so we want to use it for some record
    keeping.We don't want to spend any money on that equipment.

    regards

    Mujeeb

  2. #2
    Join Date
    Sep 2004
    Posts
    12
    Db2 is available for the following platforms:

    iSeries (formally AS/400)
    pSeries (formally RS6000)
    zSeries (formally mainframe)

    and distrubuted systems; Linux, Windows, AIX.

    IBM went thru a massive renaming plan a couple of years ago, DB2 became DB2 UDB for <insert platform name here>. I know a lot of mainframers think DB2 only exists on the Mainframe and "UDB" is for all other platforms but that's incorrect!!

    But, as with any application that is available across multiple platforms, there are differences. On the iSeries (running OS/400), you don't have to do any of the sizing allocations, reorgs, stats etc. - but you don't have the ability to partition tables (yet).

    So, you should be able to port over data between platforms - just be wary of any platform specific differences.

    By the waym DB2 on the iSeries comes as standard and is not an extra charge.

  3. #3
    Join Date
    May 2003
    Posts
    113
    they are not the same, though to external user, they are quite similar. And in normal workload, they have common features, except os/390 is faster.

    But again, they are not the same. Thus, you will expect slight different behavor if you are mid-expert level developer

    Quote Originally Posted by bmujeeb
    Is db2 on AS/400 is same as db2 on S/390.
    Very ambigious question, but we have an AS/400 and I think the
    db2 already comes with OS/400, so we want to use it for some record
    keeping.We don't want to spend any money on that equipment.

    regards

    Mujeeb

  4. #4
    Join Date
    Mar 2004
    Posts
    448
    I am talking from the perspective of a dba.
    Definatly each OS is different.
    My question are about creation of tablespaces, databases etc.
    Utilities etc , DB2 subsystem behaviour and communication etc.
    In other words, a mainframe DBA needs this percentage of extra
    knowledge to administer an DB2 on OS/400.



    regards

    Mujeeb

  5. #5
    Join Date
    Sep 2004
    Posts
    12
    There are significant differences in the Administration of both of these.

    On the iSeries you can create you tables and indexes via SQL as you would on the Mainframe. However, here are some differences on the iSeries:

    >No ability/need to create Tablespaces
    >No utility to do RUNSTATS
    >No DB2 commands (e.g. START DB)
    >DB2 logging is different - you will need to learn about Journals and journal receivers and management of them both

    Sme tasks exist on both systems, just under different names:

    LOAD = CPYF (with special parameters)
    UNLOAD = CPYF (with special parameters)
    REORG = RGZPFM
    BUILD = Have to drop / recreate
    RESTORE = RSTLIB or RSTOBJ

    And plenty more like that....

    You will need ot know what version of OS/400 you have too - there are big differences betwen say V5R1 and V4R1. Goto www.iseriesnetwork.com - they have a lot of excellent resources there as well as it's own user forum section.

    Theres just way too much to go into in this message window!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •