<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: Archiving/Deletion of WI</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi Diane,</FONT>
<BR><FONT SIZE=3D2>As far as I know, it is not a transaction but a =
database tool. You do the preparations and everything from sapdba. It =
is a technical matter, a basis consultant can help you. What I heard is =
it takes something like "days" to perform this. (of course it =
depends on the database size .... )</FONT></P>
<P><FONT SIZE=3D2>When you delete an item, the space it occupies in the =
database is not just free for new usage, you have to make a =
reorganization run so the database really "shrinks". =
Maybe you know about the scandisk and defrag tools available in Windows =
(95?) It is something like that. </FONT></P>
<P><FONT SIZE=3D2>I hope this helps.</FONT>
</P>
<P><FONT SIZE=3D2>Gulden</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Nobles, Diane [<A =
HREF=3D"mailto:nobles_dh@naptheon.com">mailto:nobles_dh@naptheon.com</A>=
]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, August 21, 2001 5:42 PM</FONT>
<BR><FONT SIZE=3D2>To: SAP-WUG@MITVMA.MIT.EDU</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Archiving/Deletion of WI</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Can you be more specific. What transaction is =
that exactly?? I have looked</FONT>
<BR><FONT SIZE=3D2>for info in Documentation and cannot locate exactly =
how to do this!!!</FONT>
</P>
<P><FONT SIZE=3D2>Diane H. Nobles</FONT>
<BR><FONT SIZE=3D2>SDE PM Team</FONT>
<BR><FONT SIZE=3D2>(757)380-7250</FONT>
<BR><FONT SIZE=3D2>------------------------------------------</FONT>
<BR><FONT SIZE=3D2>Do not render evil to anyone, but pursue</FONT>
<BR><FONT SIZE=3D2>good both for yourself and for all.</FONT>
<BR><FONT SIZE=3D2>1Thess 5:15</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Mohorcic, Marinka [<A =
HREF=3D"mailto:Marinka.Mohorcic@kcc.com">mailto:Marinka.Mohorcic@kcc.com=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, August 21, 2001 10:29 AM</FONT>
<BR><FONT SIZE=3D2>To: SAP-WUG@MITVMA.MIT.EDU</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Archiving/Deletion of WI</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>You need to run the workflow tables reorganization =
after the archiving or</FONT>
<BR><FONT SIZE=3D2>deletion. This actually releases the space =
allocated to the tables.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Marinka</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>> From: Nobles, Diane =
[SMTP:nobles_dh@naptheon.com]</FONT>
<BR><FONT SIZE=3D2>> Sent: Tuesday, August 21, 2001 9:36 AM</FONT>
<BR><FONT SIZE=3D2>> To: SAP-WUG@MITVMA.MIT.EDU</FONT>
<BR><FONT SIZE=3D2>> Subject: =
Archiving/Deletion of WI</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> I have tried to archive workitems and I have =
run rswwwide several times on</FONT>
<BR><FONT SIZE=3D2>> various tasks and on all tasks. It has =
deleted some, but the size of my</FONT>
<BR><FONT SIZE=3D2>> tables have not changed at all. The =
difference is like <1% or so. What</FONT>
<BR><FONT SIZE=3D2>> do</FONT>
<BR><FONT SIZE=3D2>> I need to do to clean these tables out.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> <<...OLE_Obj...>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> Diane H. Nobles</FONT>
<BR><FONT SIZE=3D2>> SDE PM Team</FONT>
<BR><FONT SIZE=3D2>> (757)380-7250</FONT>
<BR><FONT SIZE=3D2>> =
------------------------------------------</FONT>
<BR><FONT SIZE=3D2>> Do not render evil to anyone, but pursue</FONT>
<BR><FONT SIZE=3D2>> good both for yourself and for all.</FONT>
<BR><FONT SIZE=3D2>> 1Thess 5:15</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
-------------</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>This e-mail is intended for the use of the =
addressee(s) only and may contain</FONT>
<BR><FONT SIZE=3D2>privileged, confidential, or proprietary information =
that is exempt from</FONT>
<BR><FONT SIZE=3D2>disclosure under law. If you have received =
this message in error, please</FONT>
<BR><FONT SIZE=3D2>inform us promptly by reply e-mail, then delete the =
e-mail and destroy any</FONT>
<BR><FONT SIZE=3D2>printed copy. Thank you.</FONT>
</P>
<P><FONT =
SIZE=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>=3D=3D</FONT>
</P>
</BODY>
</HTML>