Atul, To the best of my knowledge this is only an intermediate form used to trigger and perform an action, and once that action is performed that record is no longer useful. So yes in effect you can delete the records here. I would also truncate the table to free disk space as just deleting the records will not free disk space. It will continue to hold a high water mark on that table until its truncated..
The truncate action however cannot be rolled back. So use it with care. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Atul Vohra Sent: Saturday, June 05, 2010 4:34 PM To: [email protected] Subject: SYS:Action has too many records All, We have ARS 7.1 and am seeing 243K records in the SYS:Action form. I ran a query to find count of different Actions in the table: COUNT(*) ACTION 2 DLDVALIDATEFOUNDATION 3 STARTFOUNDATIONLOAD 1018 CALLCAIPLUGIN 235169 UPDATESLMREASON 6465 CALCULATE_SLMDATES 3 INITIATEFOUNDATIONVALIDATION 1 INITIATEFOUNDATIONLOAD 21 STARTFOUNDATIONVALIDATION 140 CHECKCMDBASSOC 145 INCUPDATEGROUPLIST 248 INCREMENT_NUM_TIX 105 DECREMENT_NUM_TIX 16 DLDLOADFOUNDATION I am not sure what is the purpose of this form but some of the records are really old and am tempted to delete them. Is there any paper that talks about the SYS:Action form? Any guidance will be appreciated. Atul Vohra _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
