Question & Answer
Question
Event log table (EDIELOG) is too large to run PERFORM REMOVE LOG ENTRIES. There are over 3 million rows in the table causing REMOVE to run an exorbitant amount of time. How can this table be brought down to a more manageable size?
Answer
Use DB2 SPUFI or QMF to delete rows by date. Example SQL statement:
DELETE FROM EDIENU3x.EDIELOG
WHERE ELDATE BETWEEN '19950101' AND '20110101';
Where "x" is your current WDI release.
Note: There are no referential integrity issues with deleting rows from EDIELOG.
After the above initial clean-up, perhaps weekly, run the WDI utility command PERFORM REMOVE LOG ENTRIES or PERFORM UNLOAD LOG ENTRIES. For example:
PERFORM REMOVE LOG ENTRIES
WHERE APPLID(EDIFFS) LOGDATE(*-99999) TO(*-14)
Was this topic helpful?
Document Information
Modified date:
01 August 2018
UID
swg21188862