Results 1 to 2 of 2

Thread: Periodic Maintenance - OMW Logging Purge

  1. #1

    Periodic Maintenance - OMW Logging Purge

    Maintenance Item - OMW Logging Purge


    Description - Depending on the setup, Object Management Workbench can generate a large amount of log records in the F98210 (Log Header) and F98211 (Log Detail) over time. The default OMW logging configuration specifies full logging.

    While a reasonably well-designed database system should be able to handle a large number of records, purging the OMW log tables is certainly something worth doing on a periodic basis to maintain performance of the Object Management Logging applications (P98210). The Object Management Log Purge UBE will winnow the number of records.


    Method - R98210B


    Frequency - Monthly


    Notes- To determine the number of records in the F98210 and the F98211 one can execute the following sql script:

    <font class="small">Code:</font><hr /><pre>select count (*) from sy812.f98210
    GO
    Select count (*) from sy812.f98211
    GO </pre><hr />

    Modify the script for your E1 version/RDBMS.

    Once you have determined the number of records, hide the results from your boss so that they have no idea how badly you have been slacking for the past five years. Then find the R98210B, copy the UBE and set the processing options.

    Set to remove log records older than x number of days, where x is a number negotiated between the IT department, the development group, and possibly the internal/external auditors. Please note that the retention of OMW logs may be governed by law, company policy or a UN special task force.

    I would run the R98210B in Proof mode first before running it in Final mode.

    Run the above script again to verify the deletion of records.


    Run Method - Scheduler if possible, otherwise from a web client or on a fat client.


    Disclaimer - As with all postings please ask questions on the forum and do not contact me personally unless:

    1) you are my buddy and want to buy me a beer, 2) you wish to tell me "Happy Birthday" or 3) you wish to engage my services during December and your company is in Miami.


  2. #2
    Senior Member altquark's Avatar
    Join Date
    Oct 2000
    Location
    Kansas City, MO
    Posts
    2,640

    Re: Periodic Maintenance - OMW Logging Purge

    ummmm

    Why would you do this ?

    OMW Logging shows an audit trail of every object in the system. Purging the logs might clear some space to some degree (not much) - but realistically you'd better be confident that you know EXACTLY what has happened to your objects back when you had that weird developer who didn't really know what he was doing on staff for a month or so.

    I recommend KEEPING your OMW logs - all the way through to the next upgrade. At the point you upgrade, then you start from scratch again.

    Believe me, the times that OMW logging has saved a customers rear end from a really bad day is far more times than you can imagine. You want to know if an ESU has been applied ? Successfully ? The only way is to look at the OMW logs (unless you really enjoy reverse engineering SAR's !).

    What about truly knowing what objects have been modified by your development team ? If you're really clever, you have a helpticket system linked into OMW that can backtrack to when a user made the first complaint ! Now thats a TRUE audit trail !

    Lastly, knowing exactly what has occurred on your enterprise system is a SOX requirement for public companies. There is no statute of limitations to your auditors requiring information on how an object ended up in production. I really have a peverse satisfaction making copies of the OMW Logs and handing them to the SOX auditors in CSV format...

    So, while this is a good reference for customers to know about (and its not a knock against Jeffs' post at all, far from it) - I SERIOUSLY do not recommend removing your OMW logs.
    Jon Steel
    EnterpriseOne/SOA Technical Architect
    erpSOURCING LLC
    http://www.erpsourcing.com
    cto@spla.sh
    24/7 Assistance - (904) 382 5701

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.