Re: BPCS 6.1mm performance and the AS/400 - more ord performance

["Genyphyr Novak" <novakg@xxxxxxxx>]

PS - the ZPD file should NOT be on this list of files to automatically
clear. It contains documents that SOME customers may wish to use in document
reprinting functions. The decision on what to clear from this file and when
should not be made randomly. Check with your applications users to find out
which documents may need to be retained for reprinting and develop a
methodology to clear the file via specific SQL statements to remove records
past certain dates or only for certain document types.

I also see no file called QQWRP in our 6.1.00 environment at SSA. There is,
however a ZQWRP, and this is indeed a work file. The ZQW* files can be
cleared by going to the OEAMNU (CALL OEAMNU) and taking the option to clear
the TDR files. Users should be out of BPCS and batch processing finished
before work files are cleared. Unfortunately there is no menu option to
clean up the order entry work files, and this must be arranged in a CL
program or the like.

Thanks

Genyphyr Novak
SSA
-----Original Message-----
From: Peggy A. Heritz <pheritz@CroweChizek.Com>
To: BPCS-L@midrange.com <BPCS-L@midrange.com>
Date: Tuesday, February 15, 2000 2:43 PM
Subject: Re: BPCS 6.1mm performance and the AS/400 - more ord performance


>
>
>More info related to performance tuning for green screen order entry.
>
>In addition to ZEF, there are a number of work files that should have no
records
>in them when no one is using BPCS:
>
>
>ECHW
>ECLW
>ZPD
>EWR
>ZQWAP
>QQWRP
>ZQWSP
>DQH
>DQD
>
>
>In one client situation, after clearing these files, some responses that
were
>originally  45 seconds to 1.5 minutes went to around 5 seconds
>
>Additionally, SSA recommends the following logicals be build over order
entry
>files:
>
>file      key field(sequence)
>
>ZEF       EFKEY4(ASC)
>ELCW      CLSGRP(ASC)
>PDM       DMNMBR(ASC,DMLINE(ASC)
>ECH       HEDTE(DSC),HORD(DSC)
>ECHW      HORD(ASC),WKTYOR(ASC)
>EST       TCUST(ASC),TSHIP(ASC),STADTP(DSC)
>
>
>Peggy Heritz
>Senior BPCS Specialist
>Crowe, Chizek & Company, LLP
>http://www.crowechizek.com/scg/
>phone: 219.236.8698
>fax:        219.236.7615
>
>
>+---
>| 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
+---