DTP step taking longer time

[Former Member]

Hello Experts

As Iam new to SDN I tried to find an answer to this issue. Please find below is the Issue

There is a process chain. In this PC, After deleting the Index step, there is a DTP step, which updates the Cube with one DSO; the first DTP step is much delayed for update to cube. But where as the immediate DTP step to the same cube with another DSO is finishing so faster.

The prob is with the first DTP step which updates the cube frm DSO In this there is one Job with the namingconvention shown as BIDTPR_545787_1 was running more than 10000sec to update the Cube. Dont know why this job is running beyond so much time, where as it usually prior to some days back completes within 3000 secs.

Now the prob. is that the Data loading performance of the Prod system effected, where this DTP step is ruuning beyond time. Please can someone suggest how to find and resolve this issue as not sure why the below kind of JOBS are running for more time causing the PC much delayed for completion

BIDTPR_545787_1

BIDTPR_545689_1 etc of the First DTP are running longer. Pls help!

Regards

MD

[Former Member]

Hi,

We too face the similar problem.

Can you kindly let us know if you could find any particular reason for this behaviour.

If so, can you please tell us the fix.

Thanks in advance..

your answer helps us a lot!!!

Shylaja

[Former Member]

Hi

There could have been many reasons like

during that particular DTP is scheduled,there will not be neough work processors,this is due to the some other long running loads/jobs are running and which would have been occupied.hence during this DTP runs,parallely crosscheck in SM12,SM50&SM51.

And also check that particular job in SM37 and understand where does its taking more time.

There could have been expensive select statement,if any routines used in the transformations.

Try to find out this.

Regards

Jagadish