| Author |
Message
|
| rambo |
 Posted: Mon Mar 08, 2004 10:39 am Post subject: Solved - Audit Trail Cleanup |
 |
|
Novice
Joined: 25 Aug 2003
Posts: 20
|
Hi everyone,
Last weekend we tried to clean up our audit trail table using
FMCSCLAD /d2003-12-31 /xfinished
After 45 hours (from Friday @6PM - Sunday @1PM) the command was still running. We ran out of patience and kill the job. Currently the audit trail table contains about 1Million records. We did a test in our development environment with the same database and it took less than 21hrs. I'm not sure why it takes so long in production. Since we are not using this audit trail information in anyway, we are looking at two alternatives
1. Drop the audit_trail table and recreate it again.
2. Delete all records in this table using a delete * from fmc.audit_trail
Has anyone tried this before and if there are any complications that I should be aware of?
Thanks
_________________
Regards
Tim
Last edited by rambo on Fri Mar 12, 2004 11:40 pm; edited 1 time in total |
|
| Back to top |
|
 |
| vennela |
| Posted: Mon Mar 08, 2004 12:00 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
This is not an answer but
| Quote: |
Since we are not using this audit trail information in anyway, we are looking at two alternatives
|
Did you turn it off in first place if you don't need the audit trails? |
|
| Back to top |
|
|
| rambo |
| Posted: Mon Mar 08, 2004 1:46 pm Post subject: |
|
|
Novice
Joined: 25 Aug 2003
Posts: 20
|
Venny, thanks
Unfortunately we didn't. We are looking at turning it off also.
_________________
Regards
Tim |
|
| Back to top |
|
|
| jmac |
| Posted: Mon Mar 08, 2004 3:37 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Try using SQL to empty the table directly. I have heard that this is much faster than using fmcsclad. And DEFINITELY turn off Audit if you dont need it it is costing you about 10% cpu.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| rambo |
| Posted: Wed Mar 10, 2004 4:25 pm Post subject: |
|
|
Novice
Joined: 25 Aug 2003
Posts: 20
|
Thanks John.
_________________
Regards
Tim |
|
| Back to top |
|
|
|
|
