cancel
Showing results for 
Search instead for 
Did you mean: 

0mat_plant_attr full load - PSA growing rapidly

charla_robertson
Participant
0 Kudos

Hello,

As part of our nightly loads we are running a full load for mat plant attr. This is not our normal procedure, we are only doing it this way because our R3 and BW systems just went live for a new region and there are large volumes of change pointers being generated for mat plant. We are only doing a full load until the changes subside.

That being said, our PSA table for mat plant is growing quite rapidly (approx. 12 GB per day). We want to delete the older data from our PSA table and are wondering if there is any downfall to this. I know that once the PSA is deleted, we can no longer do a reconstruct for a particular request. But we plan on keeping the PSA for the more recent requests.

Does this sound like a bad idea to anyone? Will our current mat plant master data be impacted?

Thanks!

Charla

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Charla,

Since this is about master data and you are doing a full load everyday, deleting the PSA is not a bad idea. You can set up automatic PSA deletion in the process chain as well. The current loads will not be impacted in any way by deleting the PSA.

Hope this helps...

Answers (3)

Answers (3)

Former Member
0 Kudos

We only use the PSA for transaction data. The only time we use the PSA for master data is when we start extracting new master data, to insure that the loads are processing okay. Once we establish that there are no problems with the master data loads, we change our infopackages for master data to load directly to the target only (no PSA). This avoids scheduling cleanup of the PSA for our master data.

Hope this helps.

Former Member
0 Kudos

Hi,

Since you are doing a full load and also for MD there would be no downfall even if you delete the PSA. In fact there would be a downfall if you don't :).

Cheers,

Kedar

Former Member
0 Kudos

Hi Charla,

it is useful to keep PSA if you have delta management. With full upload it is not very useful to keep PSA (every upload is a new upload and it will overwrite completely the previous). You can delete all PSA apart yesterday PSA, only for problem in extraction in the next day.

Ciao.

Riccardo.