Housekeeping old tables in the EM640 database

Deano · Post by **Deano** » 19 Feb 2010 12:17

Hi All,

I have noticed that we have tables going back to March 2009 in the EM database and can only find entries in these for events. None of the entries are linked to an ORDER_ID, so I imagine that I can delete these tables.

Is there a 'nice' way of doing this, or do I have to delete from within SQL?

regards
Deano

hipikll · Post by **hipikll** » 19 Feb 2010 7:49

try it and let us know.

(make a db backup first)

philmalmaison · Post by **philmalmaison** » 22 Feb 2010 4:23

are you talking about AJF in EM ?
because if you're speaking about definition tables , it is a very strange question.
regards
philmalmaison

Deano · Post by **Deano** » 23 Feb 2010 12:08

philmalmaison wrote:are you talking about AJF in EM ?
because if you're speaking about definition tables , it is a very strange question.
regards
philmalmaison

No, if you look at the list of tables under 'em640' (assuming that you have the default name), you can see entries for each date and also each server. For example dbo.A081215007_ADO. These, I believe are the EM equivalent of the CMR_* tables on the server side.

Now I have looked at these old tables and the only entries I can see, appear to be event related - dbo.A081215007.AEVT includes

EVT_NO EVT_TIME EVT_TYPE
1 2008-12-15 07:00:21.000 X
2 2008-12-16 07:00:21.000 X

All other fields are NULL, so there is nothing which might tie in with a job failure....

So, these entries are no longer needed, as they are historical.

I would like to know if there is a clean way of purging these tables.

regards
Deano