Skip to Content
avatar image
Former Member

Remote Client copy

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

scc9.jpg (127.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 10, 2014 at 08:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.. ?