local Client Copy takes huge time

[Former Member]

Hi All,

Weare performing local client copy from 400 client to 210 client in Quality box for last 2 days.There is one table AUSP with 32 crore entries and the client copy is running for this

table for more amount of time

Rightnow 5 crore entries are copied  for table AUSP,Let me know if anyone can give any solution to expedite the client copy proces for this table

We have followed Parllel generator of 10 process,but still client copy has finished for all tables except this AUSP table alone.

We are monitoring tablepsaces too and we ran update stats too ,still copy is taking more amount of time

System details:solaris 10.ECC6EHP5,Oracle 11.2

Regards

Ram

[Ranjith418]

Hello Ram,

please check below.

Note 67205 - CC-INFO: Copying large and productive clients

Note 489690 - CC INFO: Copying large production clients

Thanks,
Ranjith

[Former Member]

Hi Ranjith,

Client copy finished successfully last week!!!!!

Forget to update , anyhow , it took 2 days to finish that client copy for one table with huge entries

Regards

Ram

[Former Member]

Hi ,

Please go through the below link and see whether it helps.

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

Note 446485 - CC-ADMIN: Special copying options

Try to increase the background work processes more and set the parallel RFC server to more of background work processes using RZ12.

Make sure your have run oracle update stats ...

Thanks and Regards,

Vimal

[former_member191911]

Hi Ram,

What I have done in the past, is exclude these kind of "problem" tables from the local client copy and execute them manually via R3trans.

For your currently running CC this will not be of any help, but perhaps for future runs..

Kind regards,

Mark

[Former Member]

Thanks Mark!!!

Nice to see your reply...

Let me know how to exportand  import this table via R3Trans  ????

Regards

Ram

[former_member191911]

Hi Ram,

You have to create a controlfile (AUSP.ctl) for R3trans with the following contents:

export

client = 400

file = "/usr/sap/trans/bin/data/AUSP.dat"

select * from AUSP where MANDT='400'

Execute the export via R3trans:

R3trans -w AUSP.log AUSP.ctl

Create controlfile for import (AUSP_imp.ctl)

import

client = 210

file = "/usr/sap/trans/bin/data/AUSP.dat"

R3trans -w AUSP_imp.log AUSP_imp.ctl

Make sure that the directory/filesystem where you store the export contains sufficient free space!

Hope this helps!

Kind regards,

Mark

[Former Member]

Thanks a lot mark,

Rightnow we have left with 3 tables to copy , but the screen of SCC3  shows only one table AUSP .

Is there a way to find out the rest of the 2 tables !!!!

Kindly go through the screenshot and in the meantime we will import this AUSP table as suggested by you

Regards

Ram

[former_member191911]

Hi Ram,

Maybe for the client copy log.. I don't know any other option.

Kind regards,

Mark