473,322 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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.

Harry
Aug 14 '07 #1
0 1513

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

Similar topics

1
by: Wellingotn Rampazo | last post by:
Hi guyz.... I'd like to know if anyone has already used C# components (COM+) or C# WebServices connected with Sybase System 11. Are there anyone who knows about it ? What driver version ? or...
6
by: bala | last post by:
hi access guru's there is a requirement wherein i have to connect ms access frontend with sybase (backend). the data from the frontend should be saved in the table in sybase databae thro...
1
by: Shawn | last post by:
Hi. I'm trying to save an image into a Sybase DB. The field (image_1) is of type "Blob". I have found two examples that I've tried, but no luck so far. Here is what I have done: Example 1:...
1
by: xinhuanet.com | last post by:
can you tell me how to connect to sybase database with vb.net? please give me one example.thank you!
5
by: pankaj_wolfhunter | last post by:
Greetings, In Sybase, a timestamp column is automatically loaded by the DB engine and its in some hex format. This is shown below id timestamp_value ----------- ------------------ 1...
0
by: Metal2You | last post by:
I'm working on an ASP.NET 2.0 application in Visual Studio 2005 that accesses a Sybase database back end. We're using Sybase SQL Anywhere 9.0.2.3228. I have installed and registered the Sybase...
0
by: technology_post | last post by:
Sybase Releases DataWindow .NET 2.0, Taking Data-Driven Applications from Complex to Virtually Code-Less Application Development Tool Delivers Support for the Microsoft .NET Framework 2.0 ...
26
by: codercode | last post by:
I'm working on a Visual Basic .NET using Access database. However, my client already have a 30MB database with Sybase ASA and Sybase is way too much for that. Is there anyway I can migrate from a...
1
by: anupamakrishnan | last post by:
I need to connect to sybase using MS Access.. The following methods can be used for the purpose 1. Start up MS Access. 2.1 On first use: Specify "Create a New Database Using", "Blank...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.