This website is not affiliated with, sponsored by, or approved by SAP AG.

SOLVED: PSA CLEANUP - how to with 1,5 TB?

Business Warehouse

Moderators: Snowy, thx4allthefish

SOLVED: PSA CLEANUP - how to with 1,5 TB?

Postby leschkomat » Mon Sep 06, 2010 8:38 am

Hi Guys,
we would like to cleanup our whole PSA which is like 1,5 TB big. Problem is if we do it manually with the RSA1 Standard Way, it takes forever (1 rec / sec. or even worse)
Can someone tell me how to get rid of the whole PSA at once? Drop table ? SE14 ? Or is there a special report that we should use?

Thanks in advance,
Leschkomat
Last edited by leschkomat on Thu Sep 23, 2010 8:15 am, edited 1 time in total.
leschkomat
 
Posts: 73
Joined: Thu Feb 17, 2005 2:43 am
Location: Munich

Re: PSA CLEANUP - how to with 1,5 TB?

Postby ralphreisser » Wed Sep 08, 2010 12:18 pm

Hi Leschkomat,
you can do it in the background by creating a process chain. In "Other BW Processes" select "Deletion of Requests from PSA". Enter all your PSA tables and execute the process chain. You can create several of these variances to run multiple deletions in parallel. It'll still take a while because it deletes request by request. If you think that still will take too long I would use SE14.
Regards,
Ralph
ralphreisser
 
Posts: 12
Joined: Wed Feb 02, 2005 10:34 am

Re: PSA CLEANUP - how to with 1,5 TB?

Postby leschkomat » Thu Sep 16, 2010 5:55 am

Hi Ralph,
thanks for your response!
Do you have any idea which tables i have to drop via SE14?
Is it all /BIC*-Tables?

Thanks very much for assisting me.
regards,
Carsten
leschkomat
 
Posts: 73
Joined: Thu Feb 17, 2005 2:43 am
Location: Munich

Re: PSA CLEANUP - how to with 1,5 TB?

Postby leschkomat » Thu Sep 23, 2010 8:14 am

Solution was: go the standard way and schedule the deletion per table in a process-chain.
took 2 days and now we got 1TB freespace back!
@ADMIN: PLEASE CLOSE THIS THREAD!
leschkomat
 
Posts: 73
Joined: Thu Feb 17, 2005 2:43 am
Location: Munich


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 4 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.