VL01N is taking long time in program RSM13000

[Former Member]

Dear Friends,

we have a porformance problem in VL01N transaction.

when we save delivery its taking very long time to save.

When i check workload statistical record through transaction STAD.

i got program RSM13000 is taking very high response time (ms) 1,007,128.

can anybody help how can i analyze it and fix it.

regards,

Malik

[JPReyes]

Create an SQL trace via ST05 to see which of the statements is taking a long time, then you can create a new index or update the current index.

Regards

Juan

[Former Member]

Dear Juan,

I switch on the trace for one user with specific transaction VL01N for around

2 hours.

when i check sm50 VL01N is taking time during UPD process.

But when i check the trace i can only find DIA process type trace.

Can you please tell me how can i get the trace for Update process.

Thanks with regards,

Malik

[Former Member]

Hi Malik,

Perform the trace of the transaction using st12 transaction. you may select all task by selecting '*' in the task type field.

For the traces to be performed you should be atleast on:

Patchlevel 145 for 700 kernel and

Patchlevel 193 for 640 kernel.

Regards,

Rupali

Edited by: Rupali Goyal on Jul 18, 2008 12:18 PM

[Former Member]

Thanks Juan & Rupali,

Basically we have a Z program where are using very expensive SQL

for KONV table and thats why its taking too much time.

Now we just correct the Statement and now performance of VL01N change

very very much.

Thanks with regards,

Malik

[Former Member]

Hi Malik,

Glad to hear that the performance is at its best.

Regards,

Rupali