467,887 Members | 1,594 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

Sybase to DB2 Data Movement

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.

Aug 14 '07 #1
  • viewed: 1392

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Wellingotn Rampazo | last post: by
1 post views Thread by Shawn | last post: by
1 post views Thread by xinhuanet.com | last post: by
5 posts views Thread by pankaj_wolfhunter | last post: by
reply views Thread by Metal2You | last post: by
26 posts views Thread by codercode | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.