Re: Billing Invoice Process

[andrew_murphy@xxxxxxxxxxxxxx (Murphy - Andrew)]

We have also had problems with the length of time BIL500 takes to run. We have
been informed by SSA that NO users can be on the system while this job runs so
users like ourselves which run world-wide operations on a single environment
must remove all access to BPCS (including client/server applications) while it
runs. We also use consolidated invoicing which increases run time even more!

I will certainly try creating the logicals suggested but should these be created
as logical files (i.e. DDS) or as SQL indexes (CREATE INDEX .....)? Most
documentation I have seen has recommended that indexes are created but surely
this then loses any select/omit criteria that the logical files being replaced
had?

I would be interested to hear if anyone has tried either method.

Schaff,Walter wrote:

> Juan Rodriguez of Nexgen, Inc.  has put together a very good document on "
> Using the DBMON Monitoring Tool to Improve SQL Performance "
> http://www.nexgeninfo.com/archive/DBMON.htm.  You can find some logical file
> indices recommendations at the end of the document.  I have not tried them
> myself yet. We also created the following additional logical files that help
> the billing process:
>
> EIL IORD, ILINE, IINVN, ISEQ
> RAR ARDPFX, ARDYR, ARDTYP, ARDOCN, ARWSID, RCOMP, RCUST, ARSORD
> RAR ARODPX, ARODYR, ARODTP, RINVC, ARWSID, RCOMP
> RAR RCURR, ARODPX, RINVC, ARODTP, ARODYR, RSEQ, RCOMP
> RTX TXDOCN, TXCOMP, TXCUST, TXODPX, TXINVN, TXODTP, TXODYR
> SIH IHODPX, SIINVN, IHODTP, IHODYR, SICOMP, SIORD
> SIH IHDPFX, IHDOCN, IHDTYP, IHDYR, SICOMP, SIORD
> SIL ILODPX, ILINVN, ILODTP, ILODYR, ILCOMP, ILORD, ILLINE
> SIL ILDPFX, ILDOCN, ILDTYP, ILCOMP, ILORD, ILLINE
> +---
> | 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
> +---

----------------------------------------
Andrew Murphy
XYRATEX
Havant, UK
Mailto:Andrew_Murphy@uk.xyratex.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
+---