Archiving/Deletion of WI

[Gulden Satilmis]

Hi Diane,
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 .... )
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.
I hope this helps.
 
Gulden
 
-----Original Message-----
From: Nobles, Diane [mailto:nobles_dh at naptheon.com]
Sent: Tuesday, August 21, 2001 5:42 PM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: Archiving/Deletion of WI
 
 
Can you be more specific.  What transaction is that exactly??  I have looked
for info in Documentation and cannot locate exactly how to do this!!!
 
Diane H. Nobles
SDE PM Team
(757)380-7250
------------------------------------------
Do not render evil to anyone, but pursue
good both for yourself and for all.
1Thess 5:15
 
 
-----Original Message-----
From: Mohorcic, Marinka [mailto:Marinka.Mohorcic at kcc.com]
Sent: Tuesday, August 21, 2001 10:29 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: Archiving/Deletion of WI
 
 
You need to run the workflow tables reorganization after the archiving or
deletion.  This actually releases the space allocated to the tables.
 
 
Regards,
Marinka
 
 
> -----Original Message-----
>> From: Nobles, Diane [SMTP:nobles_dh at naptheon.com]
> Sent: Tuesday, August 21, 2001 9:36 AM
> To:   SAP-WUG at MITVMA.MIT.EDU
> Subject:      Archiving/Deletion of  WI
>
> I have tried to archive workitems and I have run rswwwide several times on
> various tasks and on all tasks.  It has deleted some, but the size of my
> tables have not changed at all.  The difference is like <1% or so.  What
> do
> I need to do to clean these tables out.
>
>  <<...OLE_Obj...>>
>
> Diane H. Nobles
> SDE PM Team
> (757)380-7250
> ------------------------------------------
> Do not render evil to anyone, but pursue
> good both for yourself and for all.
> 1Thess 5:15
 
----------------------------------------------------------------------------
--
This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you have received this message in error, please
inform us promptly by reply e-mail, then delete the e-mail and destroy any
printed copy.   Thank you.
 
 ===========================================================================
==
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20010822/9a6efa84/attachment.htm