<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
We are on MSSQL Release 9.00.4035 OSS NOte 893602 is for DB2. Tried report <FONT face=Arial color=#0000ff>RSWWWIDE_DEP I got 0 Superfluous Work Items from </FONT><FONT face=Arial color=#0000ff>table SWWCNTP0. </FONT><BR>
<FONT face=Arial color=#0000ff></FONT> <BR>
<FONT face=Arial color=#0000ff>Adam</FONT><BR>
<BR> <BR>
<HR id=stopSpelling>
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<BR><BR>
<STYLE>
.ExternalClass .EC_hmmessage P
{padding-right:0px;padding-left:0px;padding-bottom:0px;padding-top:0px;}
.ExternalClass BODY.EC_hmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
<DIV dir=ltr align=left><SPAN class=EC_515445416-28082009><FONT face=Arial color=#0000ff>See prgm RSWWWIDE_DEP</FONT></SPAN></DIV>
<DIV> </DIV><SPAN style="FONT-SIZE: 8pt; COLOR: #3399cc; FONT-FAMILY: Arial"><SPAN style="FONT-WEIGHT: bold; COLOR: #000000">Rick Sample</SPAN> <SPAN style="COLOR: #000000">| </SPAN>Office (314) 573-5822<SPAN style="COLOR: #000000"> | </SPAN>Mobile (314) 952-2273<SPAN style="COLOR: #000000"> | </SPAN><A>rick.sample@graybar.com</A> <BR><A>www.graybar.com</A> - <I>Graybar Works to Your Advantage</I> </SPAN>
<DIV> </DIV><BR>
<DIV class=EC_OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma size=2><B>From:</B> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>Scheinoha, John<BR><B>Sent:</B> Friday, August 28, 2009 11:24 AM<BR><B>To:</B> SAP Workflow Users' Group<BR><B>Subject:</B> RE: Table SWWCNTP0 size 14 Million records<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff>Adam,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff> 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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff>I hope this Helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff>John Scheinoha</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_036501916-28082009><FONT face=Arial color=#0000ff>Briggs & Stratton</FONT></SPAN></DIV>
<DIV><SPAN class=EC_036501916-28082009></SPAN><FONT face=Arial><FONT color=#0000ff>(414) 256 - 5136</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><SPAN class=EC_036501916-28082009></SPAN></FONT></FONT><FONT face=Arial color=#0000ff></FONT><BR> </DIV>
<DIV class=EC_OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma><B>From:</B> sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of </B>Adam Kheil<BR><B>Sent:</B> Friday, August 28, 2009 10:19 AM<BR><B>To:</B> Workflow group<BR><B>Subject:</B> Table SWWCNTP0 size 14 Million records<BR></FONT><BR></DIV>
<DIV></DIV>Hi All,<BR>We are having a <FONT face=Arial color=#000080>growth in transactional data </FONT> issue and the sizes of these tables are growing signaficantly. <BR> <BR>SWWCNTP0 <BR>SWWLOGHI<SPAN style="DISPLAY: none">ST</SPAN><BR><SPAN style="DISPLAY: none">SWWWIHEAD</SPAN><BR><SPAN style="DISPLAY: none">SWPSTEPLOG</SPAN><BR><SPAN style="DISPLAY: none">SWPNODELOG</SPAN><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><SPAN style="DISPLAY: none"></SPAN> <BR><BR>
<HR>
Get back to school stuff for them and cashback for you. <A>Try Bing now.</A><br /><hr />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></body>
</html>