Table SWELOG & SWFREVTLOG

[Former Member]

Hi All,

In my system size for SWELOG is around 3 GB but it does not contain any entry. we were deleting entries older than 6 months continuously by program RSWELOGD. It means there is no entry generated from last 6 months.

& size for SWFREVTLOG is around 6 GB. Please tell me the relation between these two table ie SWELOG & SWFREVTLOG. Is the SWELOG obsolete in ECC 6 & replaced by SWFREVTLOG ?

Thank in advance.

Ankit

[kiran_k8]

Actually there are two programs :-

1.Prog Name RSWFEVTLOGDEL with T Code as RSWELOGD which is meant for deleting the entries from the table SWFREVTLOG.

2.Prog Name RSWELOGD with no T Code which is meant for deleting the entries from SWELTS and SWELOG.

Looking forward for some more meaningful info regarding these two Programs.

K.Kiran.

[naveen_kumar1]

Hi Ankit,

Please review note 948831.

The report RSWFEVTLOGDEL also deletes the entries from the tables

SWELOG and SWELTS as well as from the SWFREVTLOG table.

Please note for the future:

Table SWFRETLOG is the table that holds the data for the event log.

The event log should only be switched on in a production system when

you are trobuleshooting a problem as if left on it will cause

perforamance issues. Please also use transaction RSWELOGD to delete

event traces when not needed.

I hope this clarifies.

Regards,

Naveen.

[Former Member]

Hello Ankit,

Just for your information. If you want to reclaim the space from those tables, you may need to consider table reorganization.

Thanks,

Siva Kumar