Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Ketan,
Thanks for your advice.
I never saw people using this report: ZTABDEL, but will take a look at it.
Who knows it's better?
- Peter
| | | ---------------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
| |  Peter2009
SAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
