Hello all,you can also use standard BPCS depuration programs to delete message records en TELB.
Go to ECM, option 53 (program ecm803d), then type 10 in front of ECM804B.Here you can delete by date and ECA all the records in TELB file previous to the selected date.
Regards Enrique Calvín
From: "Davide Roveda" <Davide.Roveda@xxxxxxxxxxxxx> Reply-To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx> Subject: RE: [BPCS-L] URGENT! ECM - TELB file question Date: Mon, 12 Dec 2005 18:41:45 +0100 MIME-Version: 1.0Received: from bay0-mc8-f4.bay0.hotmail.com ([188.8.131.52]) by bay0-imc3-s34.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 12 Dec 2005 10:18:00 -0800 Received: from mail.midrange.com ([184.108.40.206]) by bay0-mc8-f4.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 12 Dec 2005 10:15:59 -0800 Received: from rivendell.midrange.com (localhost [127.0.0.1])by mail.midrange.com (8.13.1/8.13.1) with ESMTP id jBCHg04t012887for <enriquecalvin@xxxxxxxxxxx>; Mon, 12 Dec 2005 11:42:23 -0600 Received: from nlbaxiportp1.ssainternal.net (nlsmtpp1.ssaglobal.com[220.127.116.11])by mail.midrange.com (8.13.1/8.13.1) with ESMTP id jBCHfmIM012842for <bpcs-l@xxxxxxxxxxxx>; Mon, 12 Dec 2005 11:41:53 -0600 Received: from unknown (HELO itmiwexcu1.ssainternal.net) ([10.4.68.25])by nlbaxiportp1.ssainternal.net with ESMTP; 12 Dec 2005 18:41:52 +0100X-Message-Info: JGTYoYF78jHs1Zq9McXmM/5kgYTbecEz1q197E0pKUM= X-SBRS: None X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:messageX-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [BPCS-L] URGENT! ECM - TELB file questionThread-Index: AcX/Nq/9Svn7MX+aRHahzhqMBG89/gAC3CTgX-Virus-Scanned: ClamAV 0.87.1/1209/Mon Dec 12 09:48:01 2005 onrivendell.midrange.comX-Virus-Status: CleanX-MIME-Autoconverted: from quoted-printable to 8bit by mail.midrange.com idjBCHfmIM012842X-BeenThere: bpcs-l@xxxxxxxxxxxx X-Mailman-Version: 2.1.5 Precedence: list List-Id: SSA's BPCS ERP System <bpcs-l.midrange.com>List-Unsubscribe: <http://lists.midrange.com/mailman/listinfo/bpcs-l>,<mailto:bpcs-l-request@xxxxxxxxxxxx?subject=unsubscribe>List-Archive: <http://archive.midrange.com/bpcs-l> List-Post: <mailto:bpcs-l@xxxxxxxxxxxx> List-Help: <mailto:bpcs-l-request@xxxxxxxxxxxx?subject=help>List-Subscribe: <http://lists.midrange.com/mailman/listinfo/bpcs-l>,<mailto:bpcs-l-request@xxxxxxxxxxxx?subject=subscribe>Errors-To: bpcs-l-bounces+enriquecalvin=hotmail.com@xxxxxxxxxxxx Return-Path: bpcs-l-bounces+enriquecalvin=hotmail.com@xxxxxxxxxxxxX-OriginalArrivalTime: 12 Dec 2005 18:16:00.0125 (UTC) FILETIME=[1ABD02D0:01C5FF48]HelloGenerally 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@xxxxxxxxSent: 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. -- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: davide.roveda@xxxxxxxxxxxxx -- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: enriquecalvin@xxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.