Skip to Content
avatar image
Former Member

Client Copy Not Progressing

Hi Experts

The client copy from quality to development is not progressing after 60401 out of 60439 tables has been copied. This status has been same for the last 29 hours. Current status is showing CKIT & COSS tables are being copied.


Disk utilization at the time of writing this message is 59.3 % and CPU utilization is 32.6 %.


Please see the screen shot. What could possibly be the reason for this?

Regards,

Md. Soadrul Amin

Client Copy.png (30.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Apr 12, 2016 at 04:32 AM

    Hi Amin.

    Could you check the over all free disk space in target system (Dev).

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2016 at 07:33 AM

    Hi,

    What do you see in SM50 ? Also could you please check sm21 logs ?

    Also please paste /usr/sap/trans/log/ latest log.

    What is the value of rdisp/max_wprun_time ?

    Best Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2016 at 07:40 PM

    I have seen similar behavior. It could be that the table it is copying is huge or it has encountered an error. did you check the log in SCC3? did you check there is enough space in the tables spaces/database?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2016 at 02:33 AM

    I've seen this a number of times because of stale table statistics. Please check both tables if the statistics are still valid. Similarly, check the SQL statements running and analyze the explain plans.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2016 at 03:29 AM

    Hi,

    Could you share System logs from SM21 & SCC3 copy logs for analysis.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Krishnaiah:

      The tablespace information is a thing I have been trying to find before scheduling the client copy but cannot find in DBACOCKPIT. I know if tablespaces may require extension for a client copy.

      I am running SAP on DB/2 & IBM i 7.1.

      Regards,

      Md Soadrul Amin

  • avatar image
    Former Member
    Apr 14, 2016 at 01:18 PM

    SAP version, kernel & OS/400?

    -SAP ECC 6.0 EHP 5, Kernel Release 720, Kernel Patch 201, OS: IBM i 7.1

    SCC3 copy logs for analysis

    -Attached


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member S Sriram

      Hi Sriram:

      Before scheduling client copy, I held all background jobs on IBM i using command WRKJOBSCDE; I also suspended all background jobs on SAP application server using SA38>BTCTRNS1 and then restarted the application server to make sure no background job remains active. All users except SAP* & my own account was locked.

      However, I did not clear SQL packages. Please see the status of table name ZVATCUR in SE14. What would you suggest me to do?

      Regards,

      Md Soadrul Amin