cancel
Showing results for 
Search instead for 
Did you mean: 

Long running client deletion

Former Member
0 Kudos

   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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member188883
Active Contributor
0 Kudos

Hi Albert,

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

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks, Yves gived same link!

ACE-SAP
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Ouu, truncate?Please,tell me more about this..


Long story. Just need a copy of the productive system without application data. Only customizing.

I created new client in the system and copied customizing from PRD client(SCCL), but i need also delete productive client from system,.,Only client with cust

ACE-SAP
Active Contributor
0 Kudos

Hello

So in you scenario the SQL truncate command can help.

In fact it is a DDL (data defintion language) command, it is just resetting the table, removing all content in one pass and not deleting every row as the delete (DML command) does.

In fact it could be seen as recreating the table as empty... It might be interesting to set the

'reuse storage' clause to keep the space allocated to the table if you are planning to copy some data again to that table.

It should be used with precaution as it is not creating undo/redo info but in your scenario it is not a problem.

TRUNCATE TABLE

Regards

former_member188883
Active Contributor
0 Kudos

Hi Albert,

Refer to the link which I shared in my response earlier. It will help you analyze which tables should be considered for truncate command and speed up the deletion process.

It also has relevant SQL commands for your help.

Hope this helps.

Regards,

Deepak Kori

Reagan
Advisor
Advisor
0 Kudos

Find out the big tables. If those tables are not used by the other clients then you can truncate these tables. Start the client deletion.

Regards

RB

Former Member
0 Kudos

I have 2 clients

ACE-SAP
Active Contributor
0 Kudos

Watch out if you have two clients the truncate command will delete data from all the clients !