Activity "Calculate Access Plans (Simulation) (Optional)" Part.2

[Former Member]

Hello,

I have problems with this activity. The performance is very low. I decided to obtain the size prediction to know how much i need size for the data to be copied from Productive (sender) system to QA (reciever) system.

But can't obtain it. It gives TIME OUT(Time limit exceeded) for the program "/1CADMC/SAPLDMC000000000002448".

I tried dynamically to change the value for the parameter "rdisp/max_wprun_time" (from 1200 seconds to 3600) but the error is still the same.

It reads the table J_3RKKRS

Even i tried to comment the %HINTS in the code in the above program: (I have Oracle DataBase)

IF i_reading_type = '5'.

OPEN CURSOR WITH HOLD MY_CURSOR FOR

SELECT * FROM J_3RKKRS

BYPASSING BUFFER

WHERE (im_it_sel_criteria)

• %_hints ORACLE 'full(J_3RKKRS)'*

• DB6 '<TBSCAN>'*

• MSSQLNT 'TABLE &TABLE& INDEX(0)'*

• INFORMIX 'full(J_3RKKRS)'.*

ELSE.

OPEN CURSOR WITH HOLD MY_CURSOR FOR

SELECT *

FROM J_3RKKRS

BYPASSING BUFFER

WHERE (im_it_sel_criteria).

ENDIF.

The error is the same again.

Will it be solved if i changed the %_HINTS to not to scan all the table but with its index. Like this:

%_hints ORACLE 'INDEX ("&TABLE&" "J_3RKKRS~2" "J_3RKKRS^2")'.

Or is there another way, please help!!

Thanks in advanced,

Anatolii

[Former Member · Accepted solution]

Have you tried the note 1087374 already..There are 2 options in this note.

[Former Member · Accepted solution]

I had read it before, but this belongs to the phase of Data Transfer, but my actually status is in the phase System Analysis.

I can't continue to Data Transfer if the previous phase is not completed, right?

Anatolii