IBM Support

SQL to delete rows from Event log Tablespace (EDIELOG)

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)

[{"Product":{"code":"SSFKTZ","label":"WebSphere Data Interchange"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"WDI 3.2 for z\/OS","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"3.2;3.2.1;3.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
01 August 2018

UID

swg21188862