Determining Storage Used for WI's

[Gordy, Lynn L.]

transaction SWUF will allow you to monitor the following tables.
SWWWIHEAD
SWWLOGHIST
SWWLOGPARA
SWPSTEPLOG
SWPNODELOG
SWW_CONT
SWW_CONTOB
SWELOG
 
There is a traffic light next to each group which will turn red when the
size of the table gets too large.  There are also delete programs which you
can run to purge these tables.    We recently upgraded from 30f to 46c and
SAP highly recommends the purging of these tables for it will impact the
length of time to upgrade your box.  We purged these tables and one of them
had a red light.  It took a good month to get these tables reduced and we
had to run the delete jobs during off hours. I strongly recommend that you
implement an archiving/purging procedure now and then be in good shape for
your next upgrade.
 
lynn
 
> ----------
>> From:         Nobles, Diane[SMTP:nobles_dh at naptheon.com]
> Reply To:     SAP Workflow Users' Group
> Sent:         Wednesday, February 28, 2001 11:02 AM
> To:   SAP-WUG at MITVMA.MIT.EDU
> Subject:      Determining Storage Used for WI's
>
> Good morning all!  We are in 3.1H.  We are trying to determine the need
> for
> archiving WI's in our Production Box.  We have over 40,000 task and WF
> occurrences and well over a million WI's.  We are trying to find out the
> impact of this amount of WI on our system.  Is there a quick way to
> identify
> the storage size of WI's and the corresponding data, such as container
> data,
> and other supporting data?
>
> Diane H. Nobles
> SDE PM Team
> 380-7250
>