By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Help - Migration to DB2

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
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
Nov 12 '05 #5

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

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.