Re: CST100 - Cost Maintenance

Rick - We're 405 CD mix mode AS400 with approx 600,000 records in our CMF.

I don't know how different V6 is but in V4 there are some bugs that generate
garbage records into CMF, mainly actual cost almost duplications with no
facility (I think it is coming from CST900) ... I regularly clean out the
garbage, which comes to about 5% of file size per month.  The first time I
discovered this, we had monstrous volume of excess to get rid of.

I also have software to fix the buckets that don't add up right & have found
that running a regular SYS120 from SYS/23/12 (V4 needs extremely restricted
access until it gets done) does wonders for speed of access of several BPCS
tasks.

We rarely use simulated costs & a co-worker was asking if there's an easy way
to get rid of them ... the thought was why clutter up our data base & screens
with stuff we not using.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
http://www.globalwiretechnologies.com = new name same quality wire
engineering company: fax # 812-424-6838

>  From:    RickCarter@holley.com
>
>  BPCS 6.1.01  Mixmode    AS400  E730
>
>  The Cost Maintenance Job here takes about 1 minute and 30 seconds to bring
>  up the screen.  This used to come up much sooner but started this a few
>  months ago possibily around the time we upgraded our system to OS V4R5.
>  DBMON doesn't show a recommended logical to build over this Physical file.
>  We also have acquired all the recommended PTF's and SQL updates from IBM so
>  I don't think it's an issue with needed an SQL upgraded from IBM.
>  We have roughly 3.0 million records in our CMF file.
>  Any ideas would be appreciated.