how to set parmeter rdisp/max_wprun_time dynamically in abap

[mandeep_kauldhar]

Can we set this parmeter rdisp/max_wprun_time dynamically in abap for a particular program only? not all on instance profile level.

Mandeep

[raymond_giuseppi]

You can change rdisp/max_wprun_time in a program, but it would apply to every current process.

(Look for FM TH_CHANGE_PARAMETER)

Else execute in background job or trick system with frequent call of a FM like SAPGUI_PROGRESS_INDICATOR (but you shouldn't)

Regards,

Raymond

[mandeep_kauldhar]

If i call a program/rfc from external interface will it be considered background process or simple dialog process?

Mandeep

[raymond_giuseppi]

DIA type process - SM50 in Detail: Column Overview

There are the following work process types: 

DIA Work processes to execute:  
- UI requests 
- RFC requests 
- Internal requests 
UPD: process to execute update requests  
UP2 process to execute deferred update requests  
ENQ process to execute lock requests  
BTC process to execute background jobs  
SPO process to execute print requests  

Regards,

Raymond

[Sandra_Rossi]

Maybe your question is how to avoid a time out in a given transaction or a custom program? If it's a custom program, you may add a COMMIT WORK which resets the time out counter (there's a SAP note about it, and many placesin the forum). In that case, place it at an adequate position so that it doesn't alter the program correctness.

[mandeep_kauldhar]

Thanks Sandra, what if we have a SQL query taking longer than expected time and i want to avoid that?

Mandeep

[Sandra_Rossi]

There are many ways to increase the performance of an SQL query. It's difficult to answer. If it's a custom program, you can adjust the ABAP + open sql query (hints, parallelization, split or join tables differently). In any case, you may also do things depending on your database possibilities (hint using base line for Oracle). Really too many possibilities...