Migrating from DB2 fro os/400 to DB2 for linux.

[Pippo Pluto]

Hi all,
I have googled around but i haven't found out if this is possible and
how.
I have a as/400 with a DB2 database. This works correctly but the
as/400 uses 80% of cpu resources. So we need and upgrade. WE think we
can move the DB on a new full featured linux server with DB2 and keep
the applications on the as/400. Is it possible? I have tried to install
DB2 EE on the linux server with success, i can create dbs anda tables
ecc... Now I want to import data from the as/400, and ia tried all the
combination of the commands i have found on the web (e.g. db2 connect
... etc).
Before i waste futher time, Is possible to connect with db2cc from
linux to as/400 and then copy all the as/400 datas on the linux db?

Thank You

[GB]

Post by Pippo Pluto
Hi all,
I have googled around but i haven't found out if this is possible and
how.
I have a as/400 with a DB2 database. This works correctly but the
as/400 uses 80% of cpu resources. So we need and upgrade. WE think we
can move the DB on a new full featured linux server with DB2 and keep
the applications on the as/400.

If by "keeping the applications on the as/400" you mean running the
existing programs on the as/400 but keeping the data on the as/400, how
is that going to help the as/400 CPU utilisation?

GB

[b***@gametime.com]

I may be all wet here, but I thought AS/400 job management and real
time performance tuning was supposed to maximize cpu usage, i.e., maybe
you can run all your jobs using 20% of the cpu, but why not tweak
performance up and use 80% of the cpu and get the jobs run faster?

To my way of thinking, a computer that lets it's cpu waste cycle times
iding when it could be forcing more work through faster is inefficient.

Either your linux server can process the same work faster than the
AS/400, or it can't. As a pure database server, maybe it can (I think
it should). However, if you hang 150 terminal sessions on it, I bet it
won't match the AS/400's throughput, or even close....

Post by Pippo Pluto
Hi all,
I have googled around but i haven't found out if this is possible and
how.
I have a as/400 with a DB2 database. This works correctly but the
as/400 uses 80% of cpu resources. So we need and upgrade. WE think we
can move the DB on a new full featured linux server with DB2 and keep
the applications on the as/400. Is it possible? I have tried to install
DB2 EE on the linux server with success, i can create dbs anda tables
ecc... Now I want to import data from the as/400, and ia tried all the
combination of the commands i have found on the web (e.g. db2 connect
... etc).
Before i waste futher time, Is possible to connect with db2cc from
linux to as/400 and then copy all the as/400 datas on the linux db?
Thank You

[Dieter Bender]

Hi,

that should not be a great problem. 2 ways for example:
as400 cpytoimpf - ftp to linux - db2 import
jdbc + freeware tools

the problem you have: you have to change your application. if your programs
use sql you have minor changes (there is no connect in your apps) if your
programs use record level access you must change this to sql.

Dieter Bender

Post by Pippo Pluto
Hi all,
I have googled around but i haven't found out if this is possible and
how.
I have a as/400 with a DB2 database. This works correctly but the
as/400 uses 80% of cpu resources. So we need and upgrade. WE think we
can move the DB on a new full featured linux server with DB2 and keep
the applications on the as/400. Is it possible? I have tried to install
DB2 EE on the linux server with success, i can create dbs anda tables
ecc... Now I want to import data from the as/400, and ia tried all the
combination of the commands i have found on the web (e.g. db2 connect
... etc).
Before i waste futher time, Is possible to connect with db2cc from
linux to as/400 and then copy all the as/400 datas on the linux db?
Thank You