Making a history solution? 1

[petersJazz]

hi,

is there anyone out there having a big OneWorld system doing regular purge and some sort of history solution. Any tips on how to do it. We are using Oracle 9 and are thinking of using Oracle 9 functionality with linked files, that is putting a table in a file and link it from Oracle. This would save disk space as you can have the file on disk (without indexes) or tape.

regards

 

[BCCBIS]

I wish you luck. We have a ~750g Production database, and were looking for a Purge and Archive solution about a year ago. We ended up getting the table design layouts and writing our own. The JDE Tables are so entangled, I wouldn't recommend turning loose any automated program on it, unless it is written expressly for JDE. Not even the Oracle tools. Unless you are on an AS/400 solution, there just aren't any viable (canned) solutions out there.

If you have a large database, P&A is worth pursuing. We saved about 65g on our first purge (2 years worth of back closed sales orders). We expect to purge at least 200g before it the end of the year, and another 40g each year after that.

 

[petersJazz]

Thanks for your answer,

no we are on IBM Unix and Oracle. We need to save data for 10 years.

Did you have any kind of problems doing you own solution to the problem? Is the database concistent after running purge?

regards

 

[TAVIO2]

If you are running JDE on a 400 there are canned solutions that can help and they are JDE DB aware. One of these is ARCTOOLS, which has a JDE module, and it appears to work well. take a look. Website ARCTOOLS.com