Hello Generally you have on the ECM files the creation date. Use it to properly delete when needed, after a check. For TELB you can clean easy the one that well answer on: SELECT * FROM telb WHERE ELERR like 'UMN035%' as Msg ID Message Text 132 UMN0350 Function Started UMN0351 Function Completed Successfully UMN0353 Cycle Completed Successfully This one you have to take care Msg ID Message Text 132 UMN0352 Function Completed With Error(s) Or you can use ELGID of such a log to properly delete the file you feel old as information with (huge as time consuming for your data) SQL IN, lined via GUID. ECM803 BPCS Std function allows you to purge ECM. Do you try it? Best regards -----Original Message----- From: bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx] On Behalf Of SCarper@xxxxxxxx Sent: lunedì 12 dicembre 2005 15.24 To: bpcs-l@xxxxxxxxxxxx Subject: [BPCS-L] URGENT! ECM - TELB file question Our TELB file set up in our sister environment keeps growing and growing out of control. I have tried to match the setup of the main environment to see if there is a discrepancy in the set up, but cannot pinpoint anything. I have gone into the notification log and tried deleting very old entries, but it does not seem to affect it. The file's size has become an major problem. There are records in it from 2004. I am reluctant to simply drop records using SQL for fear it is not the proper way to handle, given ECM' s link to other files with the guid. If anyone has any insight on what we are missing.......Please help! Thanks, Sheila This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of ESAB Welding & Cutting.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.