We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Problem with very slow client deletion

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by D. Caddick (SAP NetWeaver/BASIS Consultant)
on Dec 13 at 3:27 AM
Hi Peter,

Please let the group know the findings this will be on interest to the whole group.

Regards

---------------Original Message---------------
From: Peter2009
Sent: Saturday, December 11, 2010 11:38 AM
Subject: Problem with very slow client deletion

Hi Gurus,

I'm using SAP ECC6, ORACLE 10.2.0 and HPUX B.11.23.

Currently, I'm performing a client deletion task (tx SCC5) for one of my QAS client, the database size for this client is approximately about 340GB. The job has been scheduled to execute as a background job.

I've started this job last night at about 10pm and it's still going till now, which I think it's been taking very long and getting worried why it's taking so long to complete.

When I checked in SCC3, it's showing that it's currently processing table: ACCTCR. This is the same table shown in work processes in SM50. It has been processing this table for quite some time already. Not sure why?

Below is some information from SCC3 log.

Statistics for this Run
- No. of Tables 54974 of 54992
- Deleted Lines 312619454

I've checked a few things, such as: tablespace, disk space in O/S level, short dump messages, system messages, but could not find any problem. Prior client deletion, I've already turned the archive log, so this should not be a problem.

Is this normal? What should I do now?

Is there anything to fix this problem?

Appreciate for any of your advice and help.

Thank you.


- Peter

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
D. Caddick
SAP Basis Top Contributor

Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
Most Popular White Papers

In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere. Use the New iPhone App
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language