DSXchange

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

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