Question Re: client copy exclude list in Technology Q&A

client copy exclude list

Former Member — Mon, 07 Apr 2014 19:47:34 GMT

Hi all,

We are trying to optmize the remote client copy time for 2.5 TB ECC 6.0 on sqlserver.

I have excluded the DBTABLOG,IDOC tables, BALDAT related tables, SPOOL tables,SOST...

Can we exclude SOOD,SOOS, and other SAP office related tables during client copy...

We have given 20 parallel process for the client copy with load balancing group... are there any performance tips to make the client copy faster...

Like any RFC tips and tables to exclude list...

Thanks,

Subhash.G

Re: client copy exclude list

ACE-SAP — Tue, 08 Apr 2014 00:03:54 GMT

Hello

You do not need to insert tables likes BALDAT, DBTABLOG & Spool in exception list as they are not copied be cause of their delivery class...

You can exclude cluster CDCLS if change documents are not needed

To speed up the copy you can :

1) delete the target client first.

2) insert the biggest table in the main process tab list

3) insert the other biggest tables in the table tab list (and set copy option SINGLECOPY Copy tables with exclusion mode 'S' first)

4) select copy option and SKIP_EMPTY - Skip Empty Tables

5) Check RFC quotas in R12 on the used RFC group (by default "parallel_generators")

Regards

446485 - CC-ADMIN: Special copying options

541311 - CC-INFO: Parallel processes FAQ

489690 - CC INFO: Copying large production clients

2857 - What table delivery classes are there? What is their signifi

Not copied =>

L	Table for storing temporary data
A	Applicat° table includes master & transaction data
W	System table. Contents transportable via CTS

Re: client copy exclude list

Former Member — Wed, 09 Apr 2014 19:49:43 GMT

Hi,

I am anlysing the option #3

insert the other biggest tables in the table tab list (and set copy option SINGLECOPY Copy tables with exclusion mode 'S' first)

I am in my test box and select the singlecopy option and save, now i have given table list in TABLE tab but not able to find the option mode "S".

I tried listing the tables in TAB copy individually.. that doesn't working too..

Can you please suggest how to list the table with mode "S".

Thanks,

Subhash.G

Re: client copy exclude list

ACE-SAP — Wed, 09 Apr 2014 20:15:05 GMT

Sorry I was wrong, the "table" tab is for the tables to exclude and the "Option S" for table to copy first is to set in the "Copy Individually" tab.

Deleting target client in advance can really save a lot of time so if it is possible that is a very efficient option.

Regards

Re: client copy exclude list

Former Member — Wed, 16 Apr 2014 16:43:17 GMT

Thanks, i tried the scenario and check the logs , process started for tables in single copy tab from the time we kick off the clien tcopy

Re: client copy exclude list

ACE-SAP — Wed, 16 Apr 2014 20:03:29 GMT

Ok, perfect.

Please mark the thread as answered.

Re: client copy exclude list

Former Member — Wed, 25 Feb 2015 18:04:29 GMT

What is the function of the tab: "Main Process"

What does "Assign Tables to the Main Process" tab actually do?

Re: client copy exclude list

Former Member — Mon, 02 Mar 2015 20:57:18 GMT

Any Pointers on "Main Processes", please?

Thanks,

Bidwan

Re: client copy exclude list

ACE-SAP — Mon, 02 Mar 2015 23:34:30 GMT

Main process is the 'master process' that did run in background

Main process tab allows to allocate specific table to that 'master process'

Regards

212727 - CC-INFO: FAQs for parallel processes up to Release 4.6D

9. Only the main process of the client copy can use a background process. The parallel processes are controlled via a RFC server group. However, RFC processes are always interactive processes.

Re: client copy exclude list

Former Member — Wed, 04 Mar 2015 17:31:36 GMT

Thanks!