D
Drammy
Guest
I'm with a Client that has half of their OpenEdge database filled with unwanted audit records (user built auditing; not OE auditing). The database is around 200GB and 97GB are these audit records. The user built auditing process is now disabled and not used and they simply want rid of the data.
We can't delete the data programmatically because we have no dev tools here.
The audit tables are in their own area as defined in the st file.
They've tested dumping and loading but they stopped the load after 4 days because they deemed it too long to be without their primary business database. So this is untenable in a production environment.
They've tried simply removing the data files and editing the st file but they then had problems with backup/restore - probably due to the mismatch on the st file (I wasn't around then to see the problems first hand).
What is the fastest, easiest way to get rid of this data please?
(I've asked this question on the db admin stack exchange as well - but there isn't even an OpenEdge tag in there so thought here might be better)
Continue reading...
We can't delete the data programmatically because we have no dev tools here.
The audit tables are in their own area as defined in the st file.
They've tested dumping and loading but they stopped the load after 4 days because they deemed it too long to be without their primary business database. So this is untenable in a production environment.
They've tried simply removing the data files and editing the st file but they then had problems with backup/restore - probably due to the mismatch on the st file (I wasn't around then to see the problems first hand).
What is the fastest, easiest way to get rid of this data please?
(I've asked this question on the db admin stack exchange as well - but there isn't even an OpenEdge tag in there so thought here might be better)
Continue reading...