Regarding for Client Delete

[former_member249185]

Hi All,

I want to delete client from our production system. When I start from SCC5, after some time the process takes soo much time to deleted the data. I even start this job in background. Is there any method to delete the client more fast?

Please suggest me.

Thanks & Regards,

Charanjit Singh.

[Former Member]

Hai,

Deletion speed depends upon your system configuration, since the client needs to be deleted is pretty big you have to wait.

Deleting from SAP is always better and more secure than deleting from OS level using R3trans.

Since you have selected parallel processing of R3trans as 5 this will be faster atleast to some extent.

Good luck!!

Regards,

Yoganand.V

[former_member249185]

Hi,

I have started from SAP level, using SCC5 transaction, but the problem is that there are some hugh tables which contains large transaction data. My background process hangs on that tables and after that background process goes in loop. Please suggest me for the same.

Thanks & Regards,

Charanjit Singh.

[Former Member]

hi

Then go for deletion from OS level,that will the faster way

Rohit

[Former Member]

Hi,

Follow the below steps:-

1. Create a R3trans control file ie remove_200 enter the following

in the file:

clientremove

client = 200 (*200 being the client you want to remove)

select *

2. Then from the OS command line run: R3trans -v remove_200

This will produce a file called trans.log showing the steps done.

Regards,

Ricky

[Former Member]

Hai,

Do you have enough space in PSAPROLL tablespace?

Deleting client will create huge uncommitted data, please check this..

Deleting from OS level is the only other option you have in case you still have the problem.

Regards,

Yoganand.V

[Former Member]

Hi Charanjit Singh Khalsa

you can assin through parlelljobs in that same scc5 screen, in that screen find utilities tab and select parlelljobs.

or

you can delete data from T000 table.

Regards

Bandla

[former_member249185]

Hi,

I took 5 parellel jobs for the same & client size is 390 GB.

Thanks & Regards,

Charanjit Singh.

[Former Member]

Hi Charanjit Singh

I think what you are doing is:

http://help.sap.com/saphelp_nw04/helpdata/en/69/c24c9c4ba111d189750000e8322d00/content.htm

Please check the following links:

http://www.sap-img.com/basis/proper-way-to-delete-a-sap-client.htm

and

http://www.erphome.net/pdf/saezpdf/018saez.pdf

I hope this helps

Regards

Chen

[former_member185031]

I would suggest to keep patience as this is your Production system, there is another way to delete the client from OS level, there are so many discussion on this, You can search this, but still i would recommend that have patience. and keep checking the logs and process.

Regards,

Subhash