Question:
Hi,
We got a infosource which load data into 3 ods. When trigger the data load with infopackage, the system take like 2 mins to generate a new request number and start that data load. Look like after click start, the system keep scanning system table like RSSELDONE. And, during the data load , the system's performance is very bad. Is this normal?Does anyone have same problem?Please advise. Thx
Jeff
Answer:
Forgot to mention that all 3 ods contain lots of requests.Each of them has about 700 requests.
Answer:
I do not have direct answer but you can try the following:
- Upload one ODS at a time. Use process chain to achieve this. This will reduce the pressure on the system resources. Therefore updating one ODS will be quicker.
- Ask your Basis to do Database statistics refresh with 80% of table RSSELDONE this will enhance reading performance and reduce the time required to generate new request number.
- Your Basis team needs to look at this problem and search for some related OSS notes. They might need to manipulate some system parameters.
Regards,
_________________
Ali H. Alwan
Atos Origin Middle East
Saudi Arabia
Answer:
I found a note(620361) which might relate to my problem.
=========================
Cause and preconditions
You have a data target with a large number of requests.
Since certain information of all requests is required in a data target
with the above-described actions, a relatively large number of entries
must be read and processed in different tables.
As a result, the processing times become longer and longer.
=========================
It also provide 2 solutions to improve the data load performance.
1. delete db statistics of table RSSELDONE, RSLDTDONE, RSREQDONE
---not working
2. Load the data to a copied data target and load the data back to the original one again. So, there will be only one large request in the original data target. And, you have to do this when the performance become poor again.
Anyone have this kind of problem and any other way to solve this issue.Please advise. Thx