brother_of_karamazov
Legendary Poster
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.
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.