|
How about skipping the SQL entirely -- CPYF with a field test out, and CPYF MBROPT(*REPLACE) back. You will need to to this when no one is using the file, but it will be relatively quick. CPYF FROMFILE(BPCSF/ESN) TOFILE(QTEMP/ESN) MBROPT(*REPLACE) CRTFILE(*YES) INCREL((*IF SNDESC *NE 'blah blah blah')) CPYF FROMFILE(QTEMP/ESN) TOFILE(BPCSF/ESN) MBROPT(*REPLACE) This has the added benefit of doing the reorg at the same time. BTW -- shouldn't you have some file size limits so that this doesn't happen again? a single process adding 2 million records is nuts. >>> martin@dbg400.net 01/21/03 12:00PM >>> On Tuesday 21 January 2003 5:24 pm, Dennis Munro wrote: [snip] > > Below is the SQL statement used & I am wondering is there something > that would "speed" up the process. . > > <SNIP> > DELETE FROM BPCSF/ESN WHERE SNTYPE = 'P' and SNDESC = > 'Billing date: approx. 4/15/02 March 2002 usage' > Z<SNIP> > > Sure is a simple "program" to accomplish the job but what about > performance? We run 24x7 so letting the SQL statement run some weekend > would impact the least amount of users if that is the only option & I > am not against doing that??? Hi Dennis If the records were written by the one rogue process, is there a chance that the block of records were all consecutive? If so you could delete by rrn which I think woud be quicker. delete from ESN where rrn(esn) > xxxx and rrn(esn) < yyy Regards, Martin -- martin@dbg400.net AIM/Gaim: DBG400dotNet http://www.dbg400.net /"\ DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open \ / Source free test environment tools and others (file/spool/misc) X Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news / \ _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, copying, downloading, storing or forwarding of this communication is prohibited. If you have received this communication in error, please notify us immediately via email and delete the message from your computer files and/or data base. Thank you.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
