workitem archiving

[Gregory Kowalik]

Ken,
 
SWUF shows the number of records in tables. Reorg has nothing to do with it. If
the recrods were not phisicaly deleted, reorg of those tables will not do it
either.
 
Greg
 
 
 
 
 
"Rahilly, Ken" <Ken.Rahilly at compaq.com> on 10/19/2000 12:34:36 AM
 
Please respond to "SAP Workflow Users' Group" <SAP-WUG at MITVMA.MIT.EDU>
 
To:   SAP-WUG at MITVMA.MIT.EDU
cc:    (bcc: Gregory Kowalik)
Subject:  Re: workitem archiving
 
 
 
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