workitem archiving

[Rahilly, Ken]

Morning Lynn,
 
I believe a re-org of the SWW_CONT and SWW_CONTOB tables may be helpful.
This will help gain back the space you are looking for.
 
-ken
 
-----Original Message-----
From: Gordy, Lynn L. [mailto:LLGORDY at GAPAC.com]
Sent: Wednesday, October 18, 2000 4:44 PM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: workitem archiving
 
 
We are on 3.0f and trying to archive workitems before upgrading to 46C.  I
have run the archive and delete programs for archiving workitems via SARA.
Also ran the RSWWWIDE to delete the 'C' types and RSWWHIDE to delete the
logs.  When I take a look at the tables via SWUF, the table SWWWIHEAD has
not decreased in size, nor the tables under workitem log. And, the tables
under Container, SWW_CONT and SWW_CONTOB are still gigantic.  So big in fact
that it is on red light.  The only thing that did reduce was the table under
Event Log.  That must have been from running the RSWWHIDE program. Anyway,
what can I do to get these tables to purge.
 
Your help is greatly appreciated
 
thks
Lynn