Table SWWCNTP0 size 14 Million records

[Neumann, Marcia]

Adam,

 

We began our workflow archiving out of necessity when our SWWCNTP0
reached over 89 million rows.  We currently maintain 10-11 million in
the table.  However next week that should drop significantly as we are
reducing the required aging of our most used workflow from 3 months to 1
week aging.  Although we use SAP Archive administration transaction SARA
for archive object WORKITEM to write the archive file and then delete
the rows from the database using the archive file, we don't store the
archive files for future reference as the workflow data is no longer
needed.   Only completed workflows are eligible for archiving.  We have
our workflows archived/deleted using 3 different aging variants, 1 week,
3 month and 6 month.  Each aging variant runs on a different night each
week and then the deletion from the database is done for all archive
files on Saturday.  We schedule RSARCHD for object WORKITEM to
automatically do the deletions.

 

When we started the workflow archiving we had a total of 660,000,000
rows in the tables in archiving object WORKITEM.  Now we maintain about
75,000,000 and are looking for a dramatic drop in that when we start the
one week aging of our most used workflows next week.

I hope this gives another option to think about.

Marcia Neumann 
IT Claims/CSU Development & Support 
Ext 4461 

________________________________

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

 

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. Try Bing now.
<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/2458b475/attachment.htm