We have HANA Database.
We have external Auditor, which they want to execute one report, but it's given an error system time out, can we define the rsdb/max_blocking_factor parameter into application server?
if we define, what will be the value and what will be impact into system? once we set is there any performance issue ?
Please help us share the details.
Regards
Nilesh Nanavati.
Request clarification before answering.
Changing it may impact your whole system performance. 48230 - Parameterization of SELECT ... FOR ALL ENTRIES statement - SAP for Me:
"[...] The parameters mentioned in this note have considerable effects on most of the critical database commands and influence the performance of the whole system to a great extent. For this reason, before changing the parameters described in this note, a detailed problem analysis by experienced SAP consultants or the support team is required. Note in particular that changing the parameters may often solve a local performance problem, but it may also cause a still bigger problem to occur in another place. [...]"
Better fix only the program for which you have a problem. The exact solution depends on which program it is. A timeout can be avoided by running the program in background. In dialog, maybe you can run the program by selecting less data and run it several times to cover the whole data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.