cancel
Showing results for 
Search instead for 
Did you mean: 

Remote Client copy

Former Member
0 Kudos

Hi,

We went live recently and have nearly 300 concurrent users.Production database is around 40GB. We need to take a remote client copy from PRD to QTY. I have run test copy twice and following tables take long time to process and never seems to be ending.

I have mentioned the table list that took long time to copy. I did a statistic update on those tables in PRD and QTY after canceling the first test copy ,bofore starting the second test copy.

It's took nearly 6 hours to complete 63,311 tables in test client copy.

Please help me to improve performance of the remote client copy and how can I  find the cause for long run of  following tables ?

These are all virtual servers in a IBM purefelx p servers in ibm storvie 7000. So there can not be a network bottleneck.

our system is EHP6 FOR SAP ERP 6.0in AIX 7.1 with sybase 15.7.0.122

Table Name

BCST_SR

BCST_SU

BD001

BDAUDQUEUE

SOES

SOFA

SOFD

SOFFCHKF

SOFFCHKO

SOFFCONT1

SOFFLOIO

SOFFLOIOT

SOFFLOPR

SOFFLORE

SOFFLORI

SOFFPHF

SOFFPHHR

SOFFPHIO

SOOS

SOPCPATH

SOPR

SOQUOTA

SORD

SOREORG

SORF

SORP

SORS

SORTSUBF

SOSC

SOSP_T_APPL_CH

SOSP_T_APPL_INFO

SOSP_T_APPL_TEXT

SOSP_T_BKTWFHIST

SOSP_T_BKTWIHIST

SOSP_T_BKT_PERFM

SOSP_T_MAPOBJ_T

SOSP_T_MAP_INFO

SOSP_T_MAP_OBJEC

SOSP_T_ROLETYP_T

SOSP_T_ROLE_TYPE

SOST

SOSTAT

SOSU

SOSUBUT

SOUB

SOUC

SOUD

SPBB1

SPCCNVDOCNUM

SPCDISPMESSAGES

SPCFILE

SPCGLOBAL

SPCINMAP

SPCIPCLS

SPCIPCLSIF

SPCIPCSN

SPCIPCSNT

SPCIPEFF

SPCIPFIELDLIST

SPCIPGLOBAL

SPCIPHDR

SPCIPHDRT

SPCIPINTERFACE

SPCIPMFR

SPCIPOCH

SPCIPOSDS

USR02

UST12

Accepted Solutions (0)

Answers (1)

Answers (1)

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Prabhath,

Yo can refer below notes to optimize RCC using parallel processes.

541311 - CC-INFO: Parallel processes FAQ

557132 - CC-TOPIC: Remote client copy

and below for other tweaks.

67205 - CC-INFO: Copying large and productive clients


Regards

Former Member
0 Kudos

Thanks.

I have used following options in scc9

MAX_WPRUN,

USELARGEBLOCK

Skip_empty

Parallel process

What else to use ?

Why those table take long time.. ?