Data moving from iSeries to DB2 UDB

[erkki]

Hi,

I have to move iSeries library to new DB2 database. Is there any easier
way to do this moving operation than exporting all tables in iSeries
into text files and then import them into DB2 Express?

I am looking for same kind of function like db2move between two DB2
databases.

[Joachim Klassen]

AFAIK, without DB2 Connect functionality you're lost.

With DB2 Connect you could use DB2's federated feature to integrate DB2/400
tables in a DB2 UDB database and then use UDB's LOAD FROM CURSOR to smoothly
move your data from iSeries to DB2 UDB.

HTH

Joachim

"erkki" <ma*****@operamail.com> schrieb im Newsbeitrag
news:ai*************@read3.inet.fi...

Hi,

I have to move iSeries library to new DB2 database. Is there any easier
way to do this moving operation than exporting all tables in iSeries into
text files and then import them into DB2 Express?

I am looking for same kind of function like db2move between two DB2
databases.

[Mairhtin O'Feannag]

You should look at the article :

http://www.digiampietro.com/as400/as400.html

While you will need to make adjustments to the perl script that loads the
data into XLS files, it's worth the effort to understand the process.
And perl is available for W2k.

Mairhtin

"Joachim Klassen" <jo*******@mail.com> wrote in
news:41***********************@newsread4.arcor-online.net:

AFAIK, without DB2 Connect functionality you're lost.

With DB2 Connect you could use DB2's federated feature to integrate
DB2/400 tables in a DB2 UDB database and then use UDB's LOAD FROM
CURSOR to smoothly move your data from iSeries to DB2 UDB.

HTH

Joachim

"erkki" <ma*****@operamail.com> schrieb im Newsbeitrag
news:ai*************@read3.inet.fi...

Hi,

I have to move iSeries library to new DB2 database. Is there any
easier way to do this moving operation than exporting all tables in
iSeries into text files and then import them into DB2 Express?

I am looking for same kind of function like db2move between two DB2
databases.

[erkki]

Hi,

I installed that DB2 Connect. Could you specify your idea of that load
from cursor system? Any links to guides or exapmples?

I allready managed to create connection to iSeries, but then i
discovered that there is no db2move command in DB2 Connect product...

Now I am creating a replica of that original iSeries library into DB2
UDB to get exporing enabled. But I guess there is still many problems
before data is moved...

Joachim Klassen wrote:

AFAIK, without DB2 Connect functionality you're lost.

With DB2 Connect you could use DB2's federated feature to integrate DB2/400
tables in a DB2 UDB database and then use UDB's LOAD FROM CURSOR to smoothly
move your data from iSeries to DB2 UDB.

HTH

Joachim

"erkki" <ma*****@operamail.com> schrieb im Newsbeitrag
news:ai*************@read3.inet.fi...

Hi,

I have to move iSeries library to new DB2 database. Is there any easier
way to do this moving operation than exporting all tables in iSeries into
text files and then import them into DB2 Express?

I am looking for same kind of function like db2move between two DB2
databases.

[Joachim Klassen]

Sorry for not answering your follow-on question - but it does not show up on
my news reader. I found it now on google.groups.

Anyway...

To LOAD FROM CURSOR from DB2/iSeries tables you have to set up a federated
environment in your DB2 UDB database. The steps in short (you can read about
this in the online manuals in detail)

1. set in DBM CFG FEDERATED to YES

2. Do a CREATE SERVER for your iSeries database you connected via DB2
Connect

3. Define a USER MAPPING to map your userid on your DB2 UDB host to a user
on iSeries

4. Create a NICKNAME for each iSeries Table you will load from

5. Define a Cursor with a SELECT on a NICKNAME

6. Start LOAD FROM <name> OF CURSOR

to be honest - I have not done this with Db2 UDB and iSeries but with DB2
UDB and DB2 z/os and it worked like a charm

Joachim

PS: the link to the DB2 Information Center:
http://publib.boulder.ibm.com/infoce...help/index.jsp

Hi,

I installed that DB2 Connect. Could you specify your idea of that load

from cursor system? Any links to guides or exapmples?

I allready managed to create connection to iSeries, but then i

discovered that there is no db2move command in DB2 Connect product...

Now I am creating a replica of that original iSeries library into DB2

UDB to get exporing enabled. But I guess there is still many problems

before data is moved...

Joachim Klassen wrote:

AFAIK, without DB2 Connect functionality you're lost. With DB2 Connect you could use DB2's federated feature to integrate
DB2/400 tables in a DB2 UDB database and then use UDB's LOAD FROM CURSOR to
smoothly move your data from iSeries to DB2 UDB. HTH Joachim "erkki" <ma*****@operamail.com> schrieb im Newsbeitrag news:ai*************@read3.inet.fi...

Hi, I have to move iSeries library to new DB2 database. Is there any easier way to do this moving operation than exporting all tables in iSeries into text files and then import them into DB2 Express? I am looking for same kind of function like db2move between two DB2 databases.