Solution : https://service.sap.com/sap/support/notes/1392715 (SAP Service marketplace login required)
Summary :
Poor performance during ODS request activation in SAP systems is linked to the simultaneous activation of multiple requests rich in data records, inadequate free BTC processes, suboptimal DataStore configurations (RSODSO_SETTINGS), and outdated statistics of active ODS tables. Monitoring tools such as SM51/SM50, SM21, and ST22 should be employed to identify processes and errors causing delays. Additionally, enabling SQL traces via ST05 is recommended. Adjusting RSODSO_SETTINGS to better reflect server configurations, optimizing process allocation, and revising data package sizes can enhance efficiency. Adhering to guidance in SAP Notes like 1118205 and 1157070, and managing database actions via DB20 and SID index updates can also ameliorate performance issues.
Key words :
infoobject tables803958 debuffering bw master data tables948066 performance analysis, = 3 rdisp/max_wprun_timerdisp/max_wprun_time - rz11, data loading performance/admin, memory/table space problem, update subsequent data targets, single-record buffer550784 changing, note 1157070- ensure serial loading, relevant notes- check sm21, master data upload, single record buffer
Related Notes :
| 1367407 | P23:DSO:DTP: Request list has unnecessary texts |
| 1366344 | P23:STATMAN:Manage: Poor performance if there are no texts |
| 1365901 | P23:DSO:DTP: Activation step checks long DTP requests |
| 1239127 | DB2 z/OS: BW: Parallel processing with data sharing |
| 1157070 | P18:DSO:Dump if you activate too many requests together |
| 1118205 | RSODSO_SETTINGS Maintain runtime parameter of DataStore obj. |
| 1114299 | P17:DSO:STATMANL: Activating several request; performance |
| 892513 | Consulting: Performance: Loading data, no of pkg, req size |
| 826729 | Poor performance of the single-record buffer |
| 803958 | Debuffering BW master data tables |
| 670208 | Package size with delta extraction of ODS data |
| 565725 | Optimizing the performance of ODS objects in BW 3.0B |
| 550784 | Changing the buffering of InfoObject tables |
| 384023 | Optimizing performance of ODS objects |