Haibo's Blog

Google

Saturday, April 28, 2007

Proper way to delete a SAP client

Here goes:
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 -u 1

e.g $ R3trans -w del200.log -u 1 del200
To check the progress...
$ tail -f del200

Reorg the database post client delete

1 Comments:

  • At May 23, 2007 10:17 AM, Anonymous Anonymous said…

    您好,我通过搜索找到您这里,能告诉我您的ECC是从哪买的吗,我也想买一套。
    我在北京海淀。要是方便可以给我刻一套吗,我会支付报酬的,谢谢。
    请联系:kjs100@163.com

     

Post a Comment

<< Home