|
This is exactly what we did on V4 & V6.0.02. INV900 basically only does the rollover for inventory figures now. We had a small mod done to INV900 (to remove the purge, resequence etc) then wrote in-house pgm's to do the purge and resequence later, while the users are using the system. It can take ages to run and we can't afford the down time, especially for something that can be done whilst users are on the system if coded carefully (like BPCS is!!!). An RGZPFM is done manually whenever we have the opportunity, but the reude deleted YES almost negates the need as the file stays at an 'optimal' size. Paul. At 08:34 18/11/98 -0600, you wrote: > >One thing I have been experimenting on to improve performance is to set the >all the logical files except the one's being used by INV900 to REBLD(*YES) >at the beginning of the procedure and at the end of the procedure setting >them back to REBLD(*IMMED). That way it does not have to update the indexes >of all the logical files over the ITH file while it runs. > >Another thing that can be done is move the ITH purge to a separate program >that can run when time is available - like the next weekend. > >Best Regards, >Roger Wolf > >> -----Original Message----- >> From: Michael Ozanne [SMTP:mozanne@midori-no-ryu.demon.co.uk] >> Sent: Tuesday, November 17, 1998 6:47 PM >> To: BPCS-L@midrange.com >> Subject: Re: Poor Performance in INV900 >> >> In message <912f9aa8.3651ef07@aol.com>, Devinbowen@aol.com writes >> >Does anyone know if INV900 is stricken with the same inefficient SQL >> >statement(s) as ACR900 (earlier messages)? We are in prototyping and are >> >experiencing the same kind of poor performance in the inventory month-end >> >close as was described for ACR900. We're on v6.0.02 (HP Oracle). Any >> >specifics anyone can give on a fix would be appreciated. >> >> INV900 has always been a dog, ITH is usually the biggest file in the >> database, INV900 purges old records from ITH then re-indexes it and all >> its 30 plus logical views. >> >> -- >> Michael Ozanne (Also ozannem@pacific.co.uk) >> +--- >> | This is the BPCS Users Mailing List! >> | To submit a new message, send your mail to BPCS-L@midrange.com. >> | To subscribe to this list send email to BPCS-L-SUB@midrange.com. >> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. >> | Questions should be directed to the list owner: dasmussen@aol.com >> +--- ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> ><HTML> ><HEAD> ><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> ><META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2232.0"> ><TITLE>RE: Poor Performance in INV900</TITLE> ></HEAD> ><BODY> ><BR> > ><P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">One thing I have been experimenting on to improve performance is to set the all the logical files except the one's being used by INV900 to REBLD(*YES) at the beginning of the procedure and at the end of the procedure setting them back to REBLD(*IMMED). That way it does not have to update the indexes of all the logical files over the ITH file while it runs.</FONT></P> > ><P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Another thing that can be done is move the ITH purge to a separate program that can run when time is available - like the next weekend.</FONT></P> > ><P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Best Regards,</FONT> ><BR><B><I><FONT COLOR="#000080" SIZE=7 FACE="Brush Script MT">Roger Wolf</FONT></I></B><I></I> ></P> ><UL> ><P><FONT SIZE=1 FACE="Arial">-----Original Message-----</FONT> ><BR><B><FONT SIZE=1 FACE="Arial">From: </FONT></B> <FONT SIZE=1 FACE="Arial">Michael Ozanne [SMTP:mozanne@midori-no-ryu.demon.co.uk]</FONT> ><BR><B><FONT SIZE=1 FACE="Arial">Sent: </FONT></B> <FONT SIZE=1 FACE="Arial">Tuesday, November 17, 1998 6:47 PM</FONT> ><BR><B><FONT SIZE=1 FACE="Arial">To: </FONT></B> <FONT SIZE=1 FACE="Arial">BPCS-L@midrange.com</FONT> ><BR><B><FONT SIZE=1 FACE="Arial">Subject: </FONT></B> <FONT SIZE=1 FACE="Arial">Re: Poor Performance in INV900</FONT> ></P> > ><P><FONT COLOR="#000000" SIZE=2 FACE="Arial">In message <912f9aa8.3651ef07@aol.com>, Devinbowen@aol.com writes</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">>Does anyone know if INV900 is stricken with the same inefficient SQL</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">>statement(s) as ACR900 (earlier messages)? We are in prototyping and are</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">>experiencing the same kind of poor performance in the inventory month-end</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">>close as was described for ACR900. We're on v6.0.02 (HP Oracle). Any</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">>specifics anyone can give on a fix would be appreciated.</FONT> ></P> > ><P><FONT COLOR="#000000" SIZE=2 FACE="Arial">INV900 has always been a dog, ITH is usually the biggest file in the</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">database, INV900 purges old records from ITH then re-indexes it and all</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">its 30 plus logical views.</FONT> ></P> > ><P><FONT COLOR="#000000" SIZE=2 FACE="Arial">-- </FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">Michael Ozanne (Also ozannem@pacific.co.uk)</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">+---</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| This is the BPCS Users Mailing List!</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| To submit a new message, send your mail to BPCS-L@midrange.com.</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| To subscribe to this list send email to BPCS-L-SUB@midrange.com.</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| Questions should be directed to the list owner: dasmussen@aol.com</FONT> ><BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">+---</FONT> ></P> ></UL> ></BODY> ></HTML> +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +---
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
