BODS jobs getting stuck for long time while extracting

[Moderator Note: Moved from ABOUT BOB to DATA INTEGRATOR - Chris Pohl]

Hi all,

BODS jobs are getting stuck while extracting data in production.
It has huge data ,30 million join with 8 million and staging database is DB2.
But i noticed that this occurs first job run or after job is modified.
any ideas, is it due to collect statistics? transaction logs?.
one data flow was stuck for 13 hrs in same location,no change in job count.
It completed after 13 hrs. Next run of same job took 4 hrs to complete.
The data is same.
please let me know if you any idea abt this issue.


hariprasad.panditi (BOB member since 2020-02-16)

Try Bulk Load option in Target Table

BOBJFan (BOB member since 2011-09-24)