Just in case it gives you a guess: Whe have similar behabiour, but whit Basic Programs. We use an self-made GUI-Editor that open source code from a server (using uniobjects), edit it, an then write down or not. But, if we lost the conexion with the server, then, the phisical file that had souce code, becomes 0 bytes.
Regards, ______________________________ Augusto Alonso Alonso I.T.Manager Quiter Servicios Informaticos S.L. Tel: +34 902 23 33 23 Fax: +34 902 23 42 80 [EMAIL PROTECTED] www.quiter.com ______________________________ ----- Mensaje original ----- De: "Bob Witney" <[EMAIL PROTECTED]> Para: <[email protected]> Enviado: martes, 24 de octubre de 2006 9:05 Asunto: RE: [U2] Have you ever seen this? > I'm with Charles on this > > I had a scenario a few years ago where we kept loosing the BP file > > turned out that we had an active select wish a record key of BP in it and a basic delete was isssued and that cleared out the file (yes i know it doesnt sound right but i happenend) > > I bet its a condition such as that and not malicious at all > > Bob > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, > Charles > Sent: 23 October 2006 21:04 > To: [email protected]; [EMAIL PROTECTED] > Subject: RE: [U2] Have you ever seen this? > > > My first guess would be a TCL DELETE command that was expecting a hightly restrictive select list active, but instead had the whole file. Or instead of TCL delete, it could be a basic program that did the same inside a readnext loop. > > Or what about an SQL DELETE? I think the defualt there clears a file, i.e., there is no WHERE clause. > > > One way the TCL DELETE (or loop-readnext) scenario could happen would be if there were a 2-stage select, and the second did NOT use REQUIRE.SELECT (aka SELECT.ONLY ) keyword. > > A simple example: > > SELECT MASTERf WITH AGE > TWO.YEARS SAVING LINEITEM.IDS > SELECT LINEITEM ( <---- you _n_e_e_d_ REQUIRE.SELECT here !!!! ) > DELETE LINEITEM > > Suppose the 1st select comes up blank. > Then the second will be a select list of all LINEITEM ids. > Then the DELETE effectively clears the LINEITEM file. > > That's where I would look first. > > cds > ________________________________ > > From: Patricia Wilson > > ... an incident last week were one of more heavily used files, the LINEITEM file, all of the sudden go to 0 bytes. Normally, this file has over 46K records. It wasn't a peak load time, and there haven't been any recent changes to any BP's. > We had it happen again on another system, to the same file, LINEITEM. 2 Different boxes, 2 different files (same name) @ 2 different times.... > > [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
