TX SWUF - CONT Table - Threshold for Warnings

[Quenzer, Kenneth D]

Hi Marcel,
 
The warnings seem to be based on a fixed number of records and are just
there to let you know that the workflow tables are getting very large.  At
one time our SWW_CONT table was over 57 million records and SWW_CONTOB was
over 31 million.  It is important that you keep the workflow tables
reorganized and the database statistics updates.  We have started archiving
and deleting work items and the SWW_CONT and SWW_CONTOB tables stay around
30 million records and 20 million records respectively.
 
You don't need to start archiving IDocs to get rid of the type C work items.
There is an OSS note that has the code for a report that can be used to
delete the type C work items.  We are using it and it works well.
 
Hope this helps,
Kenny Quenzer
 
-----Original Message-----
From: Landry, Marcel [mailto:MLandry at nbpower.com]
Sent: Friday, September 01, 2000 2:42 PM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: TX SWUF - CONT Table - Threshold for Warnings
 
Good Day all,
 
I am trying to get more information regarding the table size limits that
trigger warnings to be displayed in TX SWUF, the workflow Run Time Table
monitoring.
 
We have archived all possible workitems on our production system, yet tables
SWW_CONT and SWW_CONTOB are still growing at an impressive rate and we are
still getting warnings when going into SWUF.
Table SWW_CONTOB currently has just over 10 million records.
 
We do process quite a number of IDOCs and I understand that the SWW_CONT*
tables are also used to store linking documents (Type C) for IDOCS and
Application Objects.
 
We have not started archiving IDOCS yet and are not ready to do so for a
while.
 
Does anyone know how these limits for the warnings are derived ?  Is this
configurable or is it driven off the allocated table space ?
 
I have tried to find info on this topic with on-line help, OSS, etc. but
have not found anything yet.
 
Can someone provide info on what we can expect if we allow these tables to
grow much larger than their current size (already showing warnings) ?
 
 
Thanks U all in advance.
 
Marcel Landry
New Brunswick Power.