RE: performance

Lisa

INV970D and INV972D should be part of your month end procedures. The SQL
statements are extras. You are right Otto this procedure should be done
after month ends and not before (I did mention that). Lisa your month end
job INV900 should be done every month and not every year. I word of advise
when running INV900 say no to delete ITH records. When we submit the INV900
month end job it only takes 30 seconds. Saying no to delete ITH records does
speed up the process but also does not decrease the size of your ITH file.
This may be a problem if your company produces a great deal of transactions
in one day.  Twice a year (December and June) we submit INV900 saying yes to
Delete ITH records. Your right it does take a long time. Lisa take a look at
your system parms in SYS800. Look for SYS824D Transaction history parms. How
many days do you have for Inventory Transactions. We have 500 days. This
permits us to look at 2 years of stocktaking audits. You may want to
re-think this number. This is only a suggestion, your company may have other
ideas.
 

        Marc Lacelle
        Royal Canadian Mint 

> ----------
> From:         Lisa Abney[SMTP:abney@iquest.net]
> Reply To:     BPCS-L@midrange.com
> Sent:         Monday, June 21, 1999 4:33 PM
> To:   BPCS-L@midrange.com
> Subject:      Re: performance
> 
> Marc/Roger ...
> 
> We are on 4.0.5, and run INV970 as part of our normal month end.  However,
> due to the length of time it takes, we tend to skip it if the month end
> doesn't fall on a weekend (as we're really pressed to get the system back
> up
> to the users after our month end process).  The last time we did run, it
> took 4 hours on a dedicated system (and we have a pretty big box!).  Right
> now, the last time we ran it was Dec 31, and we have 917151 records in ILI
> with 0 balances, and only 35266 that are not 0!
> 
> I just ran your SQL over a test copy of ILI, and was able to delete 897668
> records (I selected with all 0's in the fields, in case it had activity
> this
> month) in less than 3 minutes ... a big improvement!  Assuming I ran the
> SQL
> statement as part of my month end (after INV900), any reason you can think
> of I couldn't run this over ILI/IWI instead of running INV970?
> 
> Lisa Abney
> 
> -----Original Message-----
> From: Lacelle, Marc <LACELLE@rcmint.ca>
> To: 'BPCS-L@midrange.com' <BPCS-L@midrange.com>
> Date: Monday, June 21, 1999 2:07 PM
> Subject: RE: performance
> 
> 
> >Hi Roger.
> >
> > I am aware of the INV970D and all of the other Reorg options
> >provided by BPCS. Beleive me,  run the SQL statements I mentioned below
> >after running the INV970D. You will be surprised.
> >
> >> ----------
> >> From: Wolf, Roger[SMTP:Roger.Wolf@garmin.com]
> >> Reply To: BPCS-L@midrange.com
> >> Sent: Monday, June 21, 1999 12:15 PM
> >> To: 'BPCS-L@midrange.com'
> >> Subject: RE: performance
> >>
> >> Forgive me.
> >>
> >> But, In BPCS405CD INV970 does the same thing.  We did one modification
> to
> >> it to test the individual fields for zero instead of in total.  The
> users
> >> wanted to see Opening Balance, receipts, adjustments and Issue.
> >>
> >> INV970 is on the system file clean up menu.
> >>
> >> Would hope there would be a similar thing in your release.
> >>
> >> Best Regards,
> >> Roger Wolf
> >>
> >> -----Original Message-----
> >> From:   Lacelle, Marc [SMTP:LACELLE@rcmint.ca]
> >> Sent:   Monday, June 21, 1999 7:51 AM
> >> To:     'BPCS-L@midrange.com'
> >> Subject:        RE: performance
> >>
> >> Hi Ho.
> >>
> >>         This one can be tried by anyone who finds that their
> >> response times
> >> are slow. This will also improve your reporting times (INV230,INV260
> >> .....)
> >>
> >> 1.      No users can be on when running these statements (very
> >> important)
> >> 2.      Do this right after month end
> >> 2.      Backup the following files (ILI, IWI)
> >> 3.      RUN THESE SQL STATEMENTS
> >> 4.      delete from ???/ili where (lopb + lrct + ladju - lissu) = 0
> >> 5.      The ??? is the name of your data library
> >> 6.      delete from ???/iwi where (wopb + wrct + wadj - wiss) = 0
> >> 7.      The ??? is the name of your data library
> >>
> >>         These statements can actually take a few minutes. It all
> >> depends on
> >> the number of records you have in these data files.
> >>
> >>         When I first wrote and tested these statements I was quite
> >> surprised
> >> to find that our ILI file went from 365,000 to 100,000 records (this
> took
> >> about 10 minutes to execute).
> >>
> >>         Enjoy
> >>
> >>         Marc Lacelle
> >>         Programmer Analyst
> >>         Royal Canadian Mint
> >>
> >>
> >>
> >> > ----------
> >> > From:
> >> jos.kramer@kaochemicals.de[SMTP:jos.kramer@kaochemicals.de]
> >> > Reply To:     BPCS-L@midrange.com
> >> > Sent:         Monday, June 21, 1999 5:16 AM
> >> > To:   BPCS-L@midrange.com
> >> > Subject:      performance
> >> >
> >> > Dear Members,
> >> >
> >> > I would like to know if someone has tips on how to improve
> performance
> >> on
> >> > the
> >> > following programms in BPCS 6.1:
> >> >
> >> > INV300, ORD550 (Action 12 allocations), ORD720 (order allocations).
> >> > Generally all the programm that use allocations are extremely slow.
> >> >
> >> > Thanks in advance,
> >> >
> >> > jos.kramer@kaochemicals.de
> >> >
> >>
> >>
> >+---
> >| 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
> >+---
> >
> 
> +---
> | 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
> +---
> 
+---
| 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
+---