AW: SWW_CONT

[Quenzer, Kenneth D]

Hi Jody,
 
I am not aware of any guideline to let you know how much data is too much.
We use SARA on a weekly basis to delete workitems that are over four months
old.  We currently have over 8,000,000 workitem headers and over 47,000,000
container instances and the performance is very good.  It is important to
reorganize the workflow tables on a regular basis to maintain performance.
You can look at oss note 72873 to see which tables to reorganize.
 
We were also concerned about losing the log information but it has not been
a problem for us.  There have only been a couple of occasions when we were
researching a problem that occurred several months ago and wished we could
have viewed the workflow log.
 
Kenny Quenzer
 
 -----Original Message-----
From:   Jody I. Chassereau [mailto:JICHASS at westvaco.com]
Sent:   Wednesday, July 18, 2001 9:56 AM
To:     SAP-WUG at MITVMA.MIT.EDU
Subject:        Re: AW: SWW_CONT
 
I am supporting workflow in a system that has been live in production for 2
months and am trying to get up to speed on my options for administration
(also new to this listserv).  I was not familiar with the SWUF transaction,
but had a look at it from all the discussion going on about work items.
Currently, we have stats of about 225,000 work headers and over 6,000,000
container instances.  The screen showing this gives green lights as the
status.
 
We have not been able to implement any kind of data archiving at this point,
but I am aware that trans SARA can be used with this.  My question to the
group is: is there a guideline to help me know when this amount of data will
be a problem?  I know as an administrator, I am constantly looking at
workflow overviews for different scenarios that have kicked off since
startup.  It is also very helpful for the users to be able to see the log
information.  I guess I thought we would not want to lose that anytime soon
by deleting work items or log data.  Maybe after a longer period of time (6
months? 1 year?), it would not be as critical.  Any suggestions on how this
is handled in other implementations would be appreciated.
 
Thanks...
 
Jody Chassereau
jichass at westvaco.com
 
>>> Marc.Giesinger at egger.com 07/18/01 10:12AM >>>
thanks to all
 
we also do not need the data in produktivsystem !
i running the deleting jobs (RSWWWIDE, RSWWHIDE and also RSWWCIDE) nearly
every week, but the SWW_CONT wont get less ... so we think something is
wrong with this part of WFD system ??
 
about 400.000 workitem header entries  in SWWIHEAD and over 16.300.000 in
SWW_CONT
 
-----Ursprungliche Nachricht-----
Von: Gregory Kowalik [mailto:gkowalik at ashland.com]
Gesendet: Mittwoch, 18. Juli 2001 15:56
An: SAP-WUG at MITVMA.MIT.EDU
Betreff: Re: SWW_CONT
 
 
I am with you Diane.
I am running deletion job in production everyday, since we don't need that
data.
I do not want to bother with creating files and then deleting them.
 
It's just general SAP's recommendation to archive.
 
Greg
 
 
 
 
 
 
"Nobles, Diane" <nobles_dh at naptheon.com>@MITVMA.MIT.EDU> on 07/18/2001
09:49:16 AM
 
Please respond to "SAP Workflow Users' Group" <SAP-WUG at MITVMA.MIT.EDU>
 
Sent by:  SAP Workflow <Owner-SAP-WUG at MITVMA.MIT.EDU>
 
 
To:   SAP-WUG at MITVMA.MIT.EDU
cc:
Subject:  Re: SWW_CONT
 
 
Please answer that question for me.  If I do not need this data, why should
I archive?? Even in Production!!
 
Diane H. Nobles
SDE PM Team
(757)380-7250
::::::::::::::::::::::::::::::::::::::::::::::
Blessed are those that hear the word
of the Lord and practice it. Luke 11:28
 
 
 
-----Original Message-----
From: Robin Sahasranam [mailto:Rsahasranam at worldbank.org]
Sent: Wednesday, July 18, 2001 9:45 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: SWW_CONT
 
 
The workitem and history deletion reports: RSWWWIDE  and RSWWHIDE
(transaction
SWUL) will delete container instances for selected workitems. You should
however
Archive and delete (transaction SARA), if possible.
 
 
 
                    Giesinger Marc
                    <Marc.Giesinger at egge        To:
Sap-Wug at Mitvma.Mit.Edu
                    r.com>                      cc:
                    Sent by: SAP                Subject:     SWW_CONT
                    Workflow
                    <Owner-SAP-WUG at MITVM
                    A.MIT.EDU>
 
 
                    07/17/2001 09:02 AM
                    Please respond to
                    SAP Workflow Users'
                    Group
 
 
 
 
 
 
 
 
Hi Folks
 
a little question about transaction SWUF "watchdog for runtime tables"
 
at the point Containber Instance we have about 16.300.000 entries in our
produktiv system  ?!
so where can i delete this intance data ??? i know its the tbles SWW_CONT
...
 
thanks in advance
 
Marc