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
BCP Load hangs
Moderators: chulett, rschirm, roy
Re: BCP Load hangs
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
Ogmios
In theory there's no difference between theory and practice. In practice there is.