<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Adam,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<div>
<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>I hope this gives another option to think about.<o:p></o:p></span></font></p>
<p><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:
Arial;color:navy'>Marcia Neumann</span></font><font color=navy><span
style='color:navy'> <br>
</span></font><font size=2 color=gray face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:gray'>I</span></font><font size=1 color=gray
face=Arial><span style='font-size:7.5pt;font-family:Arial;color:gray'>T
Claims/CSU Development & Support</span></font><font color=navy><span
style='color:navy'> <br>
</span></font><font size=1 color=gray face=Arial><span style='font-size:7.5pt;
font-family:Arial;color:gray'>Ext 4461</span></font><font color=navy><span
style='color:navy'> </span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Adam Kheil<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, August 28, 2009 1:24
PM<br>
<b><span style='font-weight:bold'>To:</span></b> Workflow group<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Table SWWCNTP0 size
14 Million records</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>We are on MSSQL Release 9.00.4035 OSS NOte 893602 is for
DB2. Tried report </span></font><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>RSWWWIDE_DEP I got 0
Superfluous Work Items from table SWWCNTP0. </span></font><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><br>
<br>
</span></font><font size=2 color=blue face=Arial><span style='font-size:10.0pt;
font-family:Arial;color:blue'>Adam</span></font><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'><br>
<br>
<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<hr size=2 width="100%" align=center id=stopSpelling>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>Subject: RE: Table SWWCNTP0 size
14 Million records<br>
Date: Fri, 28 Aug 2009 11:54:57 -0500<br>
From: Rick.Sample@graybar.com<br>
To: sap-wug@mit.edu<o:p></o:p></span></font></p>
<p class=MsoNormal><span class=ec515445416-28082009><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>See prgm
RSWWWIDE_DEP</span></font></span><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><b><font size=1 color=black face=Arial><span
style='font-size:8.0pt;font-family:Arial;color:black;font-weight:bold'>Rick
Sample</span></font></b><font size=1 color="#3399cc" face=Arial><span
style='font-size:8.0pt;font-family:Arial;color:#3399CC'> </span></font><font
size=1 color=black face=Arial><span style='font-size:8.0pt;font-family:Arial;
color:black'>| </span></font><font size=1 color="#3399cc" face=Arial><span
style='font-size:8.0pt;font-family:Arial;color:#3399CC'>Office (314) 573-5822</span></font><font
size=1 color=black face=Arial><span style='font-size:8.0pt;font-family:Arial;
color:black'> | </span></font><st1:place w:st="on"><font size=1 color="#3399cc"
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:#3399CC'>Mobile</span></font></st1:place><font
size=1 color="#3399cc" face=Arial><span style='font-size:8.0pt;font-family:
Arial;color:#3399CC'> (314) 952-2273</span></font><font size=1 color=black
face=Arial><span style='font-size:8.0pt;font-family:Arial;color:black'> | </span></font><font
size=1 color="#3399cc" face=Arial><span style='font-size:8.0pt;font-family:
Arial;color:#3399CC'>rick.sample@graybar.com <br>
www.graybar.com - <i><span style='font-style:italic'>Graybar Works to Your
Advantage</span></i> </span></font><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Scheinoha, John<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, August 28, 2009
11:24 AM<br>
<b><span style='font-weight:bold'>To:</span></b> SAP Workflow Users' Group<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Table SWWCNTP0 size
14 Million records</span></font><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoNormal><span class=ec036501916-28082009><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Adam,</span></font></span><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=ec036501916-28082009><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>
We will be upgrading from ECC 5.0 to ECC 6.0 in the upcoming weeks. Look
at <st1:City w:st="on"><st1:place w:st="on">OSS</st1:place></st1:City> 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.</span></font></span><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> <o:p></o:p></span></font></p>
<p class=MsoNormal><span class=ec036501916-28082009><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>I hope
this Helps,</span></font></span><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoNormal><span class=ec036501916-28082009><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>John
Scheinoha</span></font></span><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoNormal><span class=ec036501916-28082009><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>Briggs
& Stratton</span></font></span><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>(414) 256 - 5136</span></font><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><br>
<o:p></o:p></span></font></p>
</div>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Adam Kheil<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, August 28, 2009
10:19 AM<br>
<b><span style='font-weight:bold'>To:</span></b> Workflow group<br>
<b><span style='font-weight:bold'>Subject:</span></b> Table SWWCNTP0 size 14
Million records</span></font><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>Hi All,<br>
We are having a </span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>growth in transactional
data </span></font><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'> issue and the sizes of these tables are growing
signaficantly. <br>
<br>
SWWCNTP0 <br>
SWWLOGHIST<br>
SWWWIHEAD<br>
SWPSTEPLOG<br>
SWPNODELOG<br>
<br>
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.<br>
<br>
Thanks<br>
Adam<br>
<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Get back to school stuff for them and cashback for you.
Try Bing now.<o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=2
face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Get back to school stuff for them and cashback for you. <a
href="http://www.bing.com/cashback?form=MSHYCB&publ=WLHMTAG&crea=TEXT_MSHYCB_BackToSchool_Cashback_BTSCashback_1x1"
target="_new">Try Bing now.</a><o:p></o:p></span></font></p>
</div>
</body>
</html>