BCP Load hangs

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
yiminghu
Participant
Posts: 91
Joined: Fri Nov 14, 2003 10:09 am

BCP Load hangs

Post by yiminghu »

Hi,

I have a very strange problem. I have a BCP job which loads 3 million records from SQL Server to DB2. The first time it ran, it took less than 2 hours to finish. The second time, it hangs there for almost 6 hours, there is no activity going on SQL side or DB2 side, and there is no output file generated on DataStage server. Even though, the monitor indicates the speed is 168/second, the CPU usage is 99%. I had to kill this job anyway.

Anybody had idea about this? Does that mean I have to avoid using BCP completely?

Thanks,

Carol
Top
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: BCP Load hangs

Post by ogmios »

I completely avoid BCP. Doing BCP via DataStage is much slower than doing it yourself outside of DataStage. Shell out to a ksh script that uses bulk load. Just my 2 cents.

Ogmios
In theory there's no difference between theory and practice. In practice there is.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”