Skip to Content
0
Former Member
Apr 18, 2014 at 06:08 AM

Long running client deletion

477 Views

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.