Re: power5+ platform, DB2 for iSeries

Steve Richter wrote:
walker.l2 wrote:
1) Until v5r3 of OS/400, the IO architecture was radically different
between p5s and i5s. You could run AIX and Linux on an i5 with no
additional hardware, but running OS/400 on a p5 required additional
hardware to be installed in the p5, and you couldn't run AIX or OS/400
on an OpenPower Linux server..

At v5r4, the i5 IO architecture was changed (simplified, and made
closer to the p5 architecture);

any links that explain the i5 IO changes in v5r4?


Try a google with: i5 iop architecture v5r4

Re the OP's question:
2. Regarding DB2, how portable the database is (for example I need to
install the same database schema on AIX, Linux and AS400, what does it
mean from system support and developers point of view? (export/import,
database objects, priviledges ...)

... the book "SQL Reference for Cross-Platform Development" may be useful:
http://www.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sqlref.html
Also this porting info may be useful:
http://www.ibm.com/servers/enable/site/db2/porting.html

Re the OP's later question:
Is DB2 for iSeries really free or there are some hidden costs
regarding #of CPUs users, connectivity licenses etc... or everything
is included in the more expesive iSeries server comparing to its
"brother" pSeries?

DB2 for i5/OS is built into the operating system (no separate product to buy, install, etc). For interactive queries on green screen (STRSQL), SQL development, etc, there is another product: 5722ST1 Query Mgr and SQL Development Kit. However I believe ST1 may be bundled w/some System i models (Enterprise Edition?)

--
Karl Hanson
.

Relevant Pages

  • Re: LINUX vs AIX
    ... AIX has the best LVM implementation on any platform I've seen to date. ... > really think that real kernel issues care about whether the code is on ... > top of any given hardware, ... As Linux advocate, ...
    (comp.unix.aix)
  • Re: LINUX vs AIX
    ... Which concludes that AIX really is the only one to get it right? ... and what do you think is hardware dependent in this kernel ... >>really think that real kernel issues care about whether the code is on ... As Linux advocate, ...
    (comp.unix.aix)
  • Re: RH or SuSe Linux VS AIX
    ... But the fact of the matter is that AIX is still better for mission critical ... The LVM is second to NONE in the industry, ... Linux can however run on much of the same hardware that AIX can. ...
    (AIX-L)
  • Re: AIX on an as400 partition???
    ... Can't use a p5 LPAR box since it can only run AIX and Linux if my memory serves. ... If you are basically an AIX shop and want to run a small I5/OS partition you can do that, provided you buy the IOS hardware that allows the hardware to speak to I5 peripherals. ...
    (comp.unix.aix)
  • Re: (Xnews) Memory Problems reading goups with millions of posts - Thanks ->>> with a P.S. f
    ... need/want to DL more than 15,000 headers at once. ... You also haven't needed a PC that is a current hardware spec. ... aware of the existence of the "catch up and purge" feature, ... I also have a Linux Laptop with a 2.4 GHZ Mobile and 512 ...
    (news.software.readers)