BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

SAP BODS Jobs Running slow


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
rm24
Forum Member
Forum Member



Joined: 21 Jul 2017
ASUG Icon
Posts: 3


flag
PostPosted: Thu Dec 07, 2017 3:12 pm 
Post subject: SAP BODS Jobs Running slow

Hello,

Recently my bods job have been running slowly, from 1-2 hours to 12 hours. No change in table configuration has been changed. Data source is OLFM and target is HANA.
Back to top
prsnry
Forum Member
Forum Member



Joined: 13 Dec 2016

Posts: 6



PostPosted: Mon Jul 09, 2018 4:18 am 
Post subject: Re: SAP BODS Jobs Running slow

Few points to address here.

1) does your target table is stage table. if so it is truncate and load?
2) is your source data increasing everyday. is so, did you kept the CDC mechanism to pull the data.
3)did you kept your target and source fetch size and row per commit to 5000.
4)is there any joins you are using in your job. if so, did you put the join ranks on the tables while joining.
5)while running your job is there any other multiple jobs running on the same server. might be sometimes due multiple jobs running on server same time will cause the performance issue.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0319 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0279)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo