on 09-10-2014 9:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.