As Basis administrator, performing local client copy would recommended to be execute by the user with "SAP_ALL" authorization. The example below would be assuming the administrator with the access of the ORACLE database as well.
Prerequisite before performing client copy to avoid data in-consistencies:
1) Lock all the users by using TCODE: SM04 (By single user) / SU10 (Mass users) or AL08
2) Suspended all background process with TCODE: SE38, enter "BTCTRNS1" and click the "execute button"
3) Ensure hard disk space is sufficient Ex: using TCODE: DB02
Steps to perform local client copy:
1) Ensure the new client to be create is not in the system either using TCODE: SCC4 or from Oracle database.
- Execute: sqlplus "/ as sysdba"
- Enter: select mandt, count(*) from sapsr3.usr04 group by mandt; to show all client in the instance
2) Enter: select mandt, count(*) from sapsr3.usr04 group by mandt having mandt=702; ("No row selected" which mean is clear to proceed the client copy)
3) Create the client in the target instance, execute TCODE: SCC4 to create a new client in the list and Save
4) Login with user "sap*" on the new target client to begin the client copy
5) Execute TCODE: SCCL and select all the relevant details. Ex: profile to be create.
6) Select source client profile
7) Determine the number parallel of process and Save the setting.
8) Select "Schedule in Background Job" button instead "Start Immediately" which require the GUI to be sign-on when processing.
9) Select the "Immediately" option and click "Schedule Job" button
10) Click "Continue" button
11) The background job started
12) Execute TCODE: SCC3 to monitor the client copy progress (this can be monitor from others clients in the same instance as well)
13) Sample details of the progress on the client copy
14) Once complete, the log summary will shown.
Click File Log for details
15) With the SQL command, clearly shown users where created for the new client
16) The "success" status
17) Finally, don't forget to run the program "BTCTRNS2" to release all the background job on the source client.
