Skip to Content

Client copy of a database with some large tables

Hello Group,

I am currently performing a client copy as part of an R/3 4.6C test system refresh.

We used parallel processes which does speed the client copy up and the largest tables will always take the longest to copy. It appears to be still processing our last table which is 90Gb in size. It is currently performing a sequential read on this table and the only way I can see that it is doing anything is that it is using CPU and I/O from WRKACTJOB. The client copy has now been runnig for 2.5 days and we have a fast machine (570 with 5 CPU 70Gb Ram 4Tb DASD with 50% free)

Is anyone familair with the process or know of any other ways to work out how much longer this process will take or to check if it actually is doing something, advice would be much appreciated.

Any other experiences / tips would be welcomed. We have been looking at other thrid pary software like gold client as this process will get longer and longer as the database grows and funding for archiving projects are being withdrawn.

Best regards,

Steven

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 18, 2006 at 11:43 AM

    Hello Steven,

    the fastest and only feasible way would be a homogenous system copy with SAVLIB/RSTLIB method.

    But you have to take into account the version management, which must be saved and later is to be reimported, see note 130906.

    After the system copy you can run local client copies to rebuild your client landscape, and/or run BDLS to correct logical systems.

    Have a look at the guide for homogenous system copy

    http://service.sap.com/~sapidb/011000358700002949502001E/R3HOM.PDF

    Regards

    Guido

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Guido,

      Thanks for your repsonse.

      I did perform the homegenous system copy, but now need to recreate the same client that was in the test system before and create two additional clients for training.

      With regards,

      Steven

  • avatar image
    Former Member
    Oct 18, 2006 at 12:26 PM

    Hello Steven,

    you should rebuild the clients with local client copies, SCCL and the appropriate profile.

    If you need specific client data from the original test system, you should have performed client exports.

    Remote copy with such DB-size will not succeed.

    Regards

    Guido

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Steven Glennie

      Hello Steven,

      For the largest tables, I would run data archiving jobs to trim the data first. Likely obsolete data doesn't help much on the testing procedure anyway.

      Another aggressive approach is to execute SQL statement to trim the data. It may result in DB2-consistent but not ABAP-consistent data, and specially attention is needed for BIG Delete without frequent Commit. The advantage is that you can do it without functional people configuring the retention periods within SAP.

      Thank you,

      Victor

  • avatar image
    Former Member
    Oct 18, 2006 at 12:44 PM

    Hello Steven,

    then you can check with SCC3 which are the actual tables and with DSPFD on green screen you can see the total records.

    Regards

    Guido

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2006 at 02:58 PM

    Hi Steven,

    you could use client transport instead of homo-copy if you had problems with that. That is FAR FASTER than remote copy.

    Unfortunately 4.6D kernel has a 2GB limit and therefore needs the following parameter:

    filesplit = 2000000000

    (tpparam or tp_domain.pfl - note 86535)

    ... and with filesplit the compression ratio shrinks down from factor 10 to 2 or so ... but with 50% used of 4TB there is no issue if the trans directory is on that host.

    Then the export should be not too long - 1 day I would guess. The import can be done later on seperately but doesn't need any "clean time" for a consistent state any more 😊)

    Regards

    Volker Gueldenpfennig, consolut.gmbh

    http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Steven Glennie

      Just for future reference you can exclude tables from client copies using the program RSCCEXPT. For those tables which are huge but mean nothing in the target client this works great. Just remember to clean it up after the client copy so you don't accidentally mess up future client copies!

      Andy