I think my 6.3 install had an escalation to delete the records. The Escalation
ran daily so the daily delete was small.
It had a Run-If something like:
('Create Date' <= ($TIMESTAMP$ - (30 * 86400))) OR (( 'Create Date' <=
($TIMESTAMP$ - (4 * 86400))) AND ( 'Read' = "X"))
It did something like:
Application-Delete-Entry "$SCHEMA$" "$Request ID$"
So if the user has not read the alert within 30 days or of it has been 4 days
since they read the alert it would do a delete.
Your problem is just the initial cleanup and you could truncate the T, H, and B
tables for Alert Events as an intial cleanup. You might do an export of the
records that should remain and then import them back after the truncates are
done.
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Kendhammer, Mike
Sent: Thursday, January 10, 2008 9:01 AM
To: [email protected]
Subject: Re: Delete Records of Alert Events
Tadeu,
You could schedule an Archive on the Server Event form and just delete records
without putting them into an Archive form.
Since you have a large number of records, you could do this in batches to
delete smaller chunks at a time and this also could be done after hours...
Mike
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Thursday, January 10, 2008 7:13 AM
To: [email protected]
Subject: RES: Delete Records of Alert Events
Complementing...
I'm using:
ARS Server: ARS 7.0.01 Patch 004 - Operational System: AIX 5.3 ARS User: ARS
7.0.00 Patch 001 - Operation System: Windows XP
Database: Oracle 9i
________________________________
De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto
Dutra Pinto
Enviada: qui 10/1/2008 10:59
Para: [email protected]
Assunto: Delete Records of Alert Events
**
Hello for all,
How can I clean up records from a table that growths abnormaly??
I'm facin' a serious problem with "Alert Events" table.
Since 2004 it's been growing without control... Nowadays, this table has around
7 GB...
I want to know if have a way that I can delete all records of this table with a
security mode (not crashing the server)...
Could it be with Escalations?
If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry??
I thought in a way to delete records based in a range of date... Like taking
the date of First record saved in this table and going to deleting month by
month (in a range of a month/day)...
Is it possible??
Gimme your suggestions, please!
Thankx-in-advance...
Regards...
P.S.1: I have knowledge tha exists the Escalation "CleanUpAlertEvents" but I
think that this way will crash my ARS server if I runs it...
P.S.2: I have another tables like that... but Alert Events is the greater...
Tadeu Augusto Dutra Pinto
-----------------------------------------------------------------
IT Web Services ATM
Cinq Technologies
http://www.cinq.com.br
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Fone: 41 3018-2833 - Cinq
Fone: 41 2107-5736 - HSBC Outsourcing
-----------------------------------------------------------------
Confiabilidade, Inovação e Qualidade em T.I.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"