4 Replies Latest reply: Apr 19, 2010 4:00 PM by Shapuan Abdul Kadir RSS

Remote client copy

Shapuan Abdul Kadir
Currently Being Moderated

Hi,

 

I'm doing remote client copy from Production to QAS using SAP_ALL. Customer just provide us time about 2 days. But

this client copy running too long until we need to cancel since not enough time. Any idea that I can speed up this client copy?

 

 

The production database size is 68,344,896kb. We use 6 parallel process. Sometimes in sm50 I can see the client copy job

on hold and sleep? Wat does it mean, is it because of this reason our client copy taken too long to complete.

 

Please advise.

 

Thanks

  • Re: Remote client copy
    Bhavik  G. Shroff
    Currently Being Moderated

    Hi,

     

    Have you analyzed SM21, ST22 , SCC3 logs?

     

    Also check the CPU/Memory availability at Source & Target Systems. Two copy processes per CPU count are recommended.

     

    Have you disabled Archive log mode in ur QAS system before performing actual Client Copy, this can be helpful in speedup the client copy process ? Before activating/deactivating archive mode Offline backup of System DB is recommended to guarantee the Complete DB Recovery.

     

    DB Reorganization and Updating DB Statistics in Source system's DB before Client copy, can speedup the Client Copy process.

     

    Regards,

    Bhavik G. Shroff

  • Re: Remote client copy
    Shapuan Abdul Kadir
    Currently Being Moderated

    Solution is by doing client export and import.

    It's really fast by doind client export/import

    than doing remote client copy.