Help - Migration to DB2

[pankaj_wolfhunter@yahoo.co.in]

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]

Re: Help - Migration to DB2

pankaj_wolfhunt er@yahoo.co.in wrote:
[color=blue]
> We are doing data-migration from Oracle To DB2. Can anyone tell me the
> best way to work with lob data?[/color]

What exactly is the problem/question?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[juliane26]

Re: Help - Migration to DB2

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/developerworks/db2/zones/porting/index.html

[pankaj_wolfhunter@yahoo.co.in]

Re: Help - Migration to DB2

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]

Re: Help - Migration to DB2

pankaj_wolfhunt er@yahoo.co.in wrote:[color=blue]
> 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
>[/color]
send a note to mtk@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@yahoo.co.in]

Re: Help - Migration to DB2

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