We had the same issue and filed an incident with BMC. They had us use a SQL statement to delete all the records. To delete them manually or with an escalation would supposedly result in other issues. I suggest you file a ticket with BMC and have them help you clean it properly. Once we did, they had us had some work flow related to SLM that stopped the problem we were having with too many records
Kelly Deaver
L-3 Stratis / FAA Contractor
Kelly Deaver
L-3 Stratis / FAA Contractor
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_-------- Original Message --------
Subject: SYS:Action has too many records
From: Atul Vohra <a...@protechsoftwareinc.com>
Date: Sat, June 05, 2010 3:33 pm
To: arslist@ARSLIST.ORG
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"
