Skip to Content
avatar image
Former Member

Long running client deletion

Hello all

How can I speed up the removal of the big productive client?

I use:

1) No Archive log mode

2) Parralel processing

I reran the removal of 4 times. Total removed about 500 million entires from 1 200 billion

There are very few tables, but I think it is a large tables

Please,see part of the client deletion information.

Current Action:

Copy/Delete Tables

Process

Server

Table

Time

MVKE

15:46:36

00002

CDCLS

16:28:49

00004

BDCP2

16:25:52

00005

MARC

15:48:07

00007

CKMLPR

16:09:21

00008

MSTA

15:46:41

00009

FAGLFLEXA

15:36:21

00010

FAGL_SPLINFO

15:33:26

00011

MOFF

15:46:17

00014

MBEWH

16:30:05

00016

CDHDR

16:28:52

Statistics for this Run

- No. of Tables

65979 of

66248

- Number of Exceptions

3

- Deleted Lines

62747951

Sm66:

SAPLSCCR Direct Read MSTA

SAPLSCCR Direct Read CDHDR

SAPLSCCR Direct Read CKMLPR

SAPLSCCR Direct Read MOFF

SAPLSCCR Direct Read MBEWH

SAPLSCCR Direct Read BDCP2

SAPLSCCR Direct Read MARC

SAPLSCCR Direct Read FAGLFLEXA

SAPLSCCR Direct Read CDCLS

SAPLSCCR Direct Read FAGL_SPLIN

SAPLSCCR Direct Read MVKE

Only direct read, and nothing else.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 18, 2014 at 07:18 AM

    Hello,

    If your system is productive it should only have only one client... thus you could just truncate the application tables instead of deleting their content. Truncate command is instantaneous.

    Why are you deleting a client from a (copy of a) productive system ?

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2014 at 07:41 AM

    Hi Albert,

    Refer to the blog on how to speed up client deletion .

    How to speed up client deletions

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded