Help - Migration to DB2

[pankaj_wolfhunter]

We are doing data-migration from Oracle To DB2. Can anyone tell me the
best way to work with lob data?
Any help will be greatly appreciated.

TIA

[Knut Stolze]

pa***************@yahoo.co.in wrote:

We are doing data-migration from Oracle To DB2. Can anyone tell me the
best way to work with lob data?

What exactly is the problem/question?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[juliane26]

http://www-306.ibm.com/software/data/db2/migration/mtk/

Try it, but I have to admit I never tried it with large objects

http://www-128.ibm.com/developerwork...ing/index.html

[pankaj_wolfhunter]

Knut, Juliane, Thanks for the replies.

Knut: Actually when we spool out the large data out of oracle tables,
it gets into a file without any record delimiter. what we want is, how
can we load this file into a table in db2 without specifying the record
delimiter. I read documentation which says that we can specify
lobsinfile parameter but then we have to specify the location of the
file consisting of lobs record. but when we spool out of oracle tables
there is no separate file getting generated i. e all the records
including the lobs are there in one file only. How can we load this
into db2 tables.

TIA

[Serge Rielau]

pa***************@yahoo.co.in wrote:

Knut, Juliane, Thanks for the replies.

Knut: Actually when we spool out the large data out of oracle tables,
it gets into a file without any record delimiter. what we want is, how
can we load this file into a table in db2 without specifying the record
delimiter. I read documentation which says that we can specify
lobsinfile parameter but then we have to specify the location of the
file consisting of lobs record. but when we spool out of oracle tables
there is no separate file getting generated i. e all the records
including the lobs are there in one file only. How can we load this
into db2 tables.

TIA

send a note to mt*@us.ibm.com
I'd guess this is part of their daily life...

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[pankaj_wolfhunter]

many thanks Serge. I'll do that. I hope if any problem i can always get
back to you. :-)