|
Thanks to all that answered. Martin, your thought about the records all being contiguous was correct. I used Linoma Software Surveyor File Edit process which shows the rrn & filtered each p/o group & deleted the records by the rrn range. I did it on the production box after 5 PM & the time to delete the 6.4 million+ records was about 25 minutes which included the time to get the logicals back in synch. I had done a CPYF to a work file & run the SQL delete by rrn against the work file & it took less than 8 minutes BUT there were no logicals over it & I was the only one using the file. Richard & Tom mentioned the CPYF process & that would have been my next attempt if the SQL would not have worked out. I do have to run the CPYF to get rid of the deleted records but I will wait until month-end & get rid of the deleted records. Again, thanks to all for their suggestions. Thanks - Dennis. Dennis Munro "I love deadlines. I especially like the whooshing sound they make as they go flying by." Dilbert's Words Of Wisdom: Badger Mining Corporation www.badgerminingcorp.com dmunro@badgerminingcorp.com (920) 361-2388 -----Original Message----- From: Chris Bipes [mailto:chris.bipes@cross-check.com] Sent: Tuesday, January 21, 2003 4:22 PM To: 'Midrange Systems Technical Discussion' Subject: RE: SQL Delete question Run your SQL statement from Ops Nav or MS SQL. It then runs as Client/Server. I am moving away from STRSQL to PC based packages. In Ops Nav highlight databases, The lower plane shows "Run an SQL Script". -----Original Message----- From: Dennis Munro [mailto:DMunro@badgerminingcorp.com] V5R1M0 fairly current on all group/cum ptf's The PO processing in BPCS must have gone haywire one day because I had 2, 085,055 notes written for one given PO - possibly a P/C locked up but who will remember what happened 10+ months ago. When I go to delete them using SQL, I aborted the job after 35 minutes because I just had no clue how long it would take plus I had to get home. Looking at it today, I did get about 1,350,000 records deleted in that time frame. This was run on our test box which is a 720 & I was the only person signed on at the time My production machine is an 820 with 35(???) interactive and I guess I am making the assumption that STRSQL is a green screen/interactive job & what would be a way to better delete this number of records? The real problem is the above scenario happened three times so I have 6,444,070 ESN records to be deleted. I would get killed if I ran that during the day with that kind of performance hit. Below is the SQL statement used & I am wondering is there something that would "speed" up the process. . _______________________________________________ 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. The information contained in this e-mail message is confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone, and return the original message to us at the below address via the U.S. Postal Service, and delete it from your computer. Badger Mining Corporation P.O. Box 328 Berlin, WI 54923 920-361-2388
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.