Determining Storage Used for WI's

[Todd Walter]

Diane,
 
I don't know a real clean way, but one approach you can do is to find the
tables associated with the archiving object WORKITEM.  I can't remember if
SAP included the link to the associated DB tables through the archiving
transaction in 3.1 or 4.0.  To find out, go to transaction SARA and enter
the object name WORKITEM.  See if you see a button or link to DB tables.  If
not, go to SE16 and look at the table ARCH_DEF.  Enter WORKITEM in the
'Object' field and execute.  This will return all of the DB tables
associated with the object.  Once you get your table list, you can go to
transaction DB02 and obtain the current space being used for each table.  I
believe the main tables are SWWWIHEAD, SWW_CONTOB, and SWWLOGHIST.  Hope
this helps.
 
Todd
 
>From: "Nobles, Diane" <nobles_dh at naptheon.com>
>Reply-To: SAP Workflow Users' Group <SAP-WUG at MITVMA.MIT.EDU>
>To: SAP-WUG at MITVMA.MIT.EDU
>Subject: Determining Storage Used for WI's
>Date: Wed, 28 Feb 2001 11:02:45 -0500
>
>Good morning all!  We are in 3.1H.  We are trying to determine the need for
>archiving WI's in our Production Box.  We have over 40,000 task and WF
>occurrences and well over a million WI's.  We are trying to find out the
>impact of this amount of WI on our system.  Is there a quick way to
>identify
>the storage size of WI's and the corresponding data, such as container
>data,
>and other supporting data?
>
>Diane H. Nobles
>SDE PM Team
>380-7250
 
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com