<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN
class=480350320-04022000>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=480350320-04022000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=480350320-04022000>We have a large
volume workflow implementation (approximately 50,000 work items per day) and are
currently trying to decide whether to delete old work items via the archive
object or to use the deletion reports. We have written our own deletion
report which utilizes RSWWWIDE and RSWWHIDE to delete the work items and their
history. The problem with this report is that it takes a very long time to
delete a large number of work items. It is my understanding that it is
much quicker to delete work items via the archive object WORKITEM. OSS
note #145291 says that the runtime of the deletion process can be reduced by a
factor of 10 after applying the note.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=480350320-04022000>I would like to
delete old work items using the archive process but according to note #117191
the work item history is only deleted from the flow items and not the
subordinate work items. Also, it would be difficult to delete the work
item history of the subordinate work items using RSWWHIDE since the only
selection criteria is work item number.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=480350320-04022000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=480350320-04022000>Has anyone
implemented an archive/deletion process for work items? If so, how did you
get around the problem with the work item history?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=480350320-04022000></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=480350320-04022000>Thanks,</SPAN></FONT></DIV>
<DIV>Kenny Quenzer</DIV>
<DIV><FONT face=Arial size=2>CCS Support Coordinator</FONT></DIV>
<DIV><FONT face=Arial size=2>405-553-2256</FONT></DIV>
<DIV><FONT face=Arial size=2><A
href="mailto:quenzekd@oge.com">quenzekd@oge.com</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>