Table SWWCNTP0 size 14 Million records

[Adam Kheil]

We are on MSSQL Release 9.00.4035 OSS NOte 893602 is for DB2. Tried report RSWWWIDE_DEP I got 0 Superfluous Work Items from table SWWCNTP0. 

 

Adam


 


Subject: RE: Table SWWCNTP0 size 14 Million records
Date: Fri, 28 Aug 2009 11:54:57 -0500
From: Rick.Sample at graybar.com
To: sap-wug at mit.edu




See prgm RSWWWIDE_DEP
 Rick Sample | Office (314) 573-5822 | Mobile (314) 952-2273 | rick.sample at graybar.com 
www.graybar.com - Graybar Works to Your Advantage 
 



From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Scheinoha, John
Sent: Friday, August 28, 2009 11:24 AM
To: SAP Workflow Users' Group
Subject: RE: Table SWWCNTP0 size 14 Million records



Adam,
 
   We will be upgrading from ECC 5.0 to ECC 6.0 in the upcoming weeks.  Look at OSS Note 893602.  It references other SAP OSS Notes and Oracle Notes for scheduling re-org jobs, reconstruction options and re-organizing Oracle tables.  I have seen other SAP Workflow User Group e-mails in this same topic.
 
 
I hope this Helps,
John Scheinoha
Briggs & Stratton
(414) 256 - 5136

 


From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Adam Kheil
Sent: Friday, August 28, 2009 10:19 AM
To: Workflow group
Subject: Table SWWCNTP0 size 14 Million records


Hi All,
We are having a growth in transactional data  issue and the sizes of these tables are growing signaficantly. 
 
SWWCNTP0 
SWWLOGHIST
SWWWIHEAD
SWPSTEPLOG
SWPNODELOG
 
However, active number of work items are very minimal. What is a best approach to reduce the size of these. archiving? Any ideas will be highly appreciated. We are on ECC6.
 
Thanks
Adam
 



Get back to school stuff for them and cashback for you. Try Bing now.
_________________________________________________________________
Get back to school stuff for them and cashback for you.
http://www.bing.com/cashback?form=MSHYCB&publ=WLHMTAG&crea=TEXT_MSHYCB_BackToSchool_Cashback_BTSCashback_1x1
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20090828/eb7f17d9/attachment.htm