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

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.

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

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

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!!