Thursday, 5 December 2013

How to Delete a client with R3trans command


1. log into the client to delete 
2. go into SCC5 and delete client 
3. log into another client and delete entry with SCC4 
4. reorg database to recover database space. 


Actually, if you check "on" the little "Delete Entry from T000" checkbox, you can skip step 3.

One other way of deleting a client which could give significant performance gain and save time is at OS level using - R3trans 
To delete a client 200, you have to create a command file "del200" with following entries 

Clientremove 
Client = 200 
Select * 


Place the command file in /usr/sap/trans/bin 

$ cd /usr/sap/trans/bin 

$ R3trans –w <log file name> -u 1 <command file name > 

e.g $ R3trans -w del200.log -u 1 del200 

To check the progress... 

$ tail -f del200 
 

Reorg the database post client delete 




THANK YOU

No comments:

Post a Comment