Hi All,
We are in the process to migrate one of our database from Sybase to DB2 9. We use MTK to move database objects. Now facing issues in moving tables with TEXT field in Sybase to DB2 ( In DB2 "TEXT" datatype is mapped to CLOB).
We are having problems loading/unloading huge tables using bcp, so I was wondering if anyone could give us some advice on that. Here are a couple of questions I have:
1. When I'm bcp-ing out, the dump file is huge ~ 199 Gb, there's no space to have the whole file written out, so what we are trying to do is to have bcp write out the multiple files and then have them loaded as they are being written out. Is there a way to instruct bcp to unload data into multiple files, each containing X number of records? (The -F -L option is not suitable for large amounts of data.)
2. How can we bcp out a table with a TEXT column type (it's a LOB type, max size is in Gb's), so that all normal columns go to the usual bcp out file and all TEXT columns into a separate file - either one for all rows or separate files with some sort of predictable naming convention (so that DB2 Load will use the separate file as Lobs file) . I tried using views on the table (One for Text field & another for all other columns) and bcp out the data, but the question is How DB2 Load will recognise the Text column bcp output as Load file.
I would really appreciate your help with this.
Thanks in advance.
Harry