RE: Duplicates in BPCS files - illusion?

[Paul King <Paul@xxxxxxxxxxxxxx>]

None that I'm aware of. We have some very complex in house posting programs
for which we use commitment control. One in particulrar is SFC posting /
backflushing for in-line inventory updating (updates ITH, ILI, IWI, FSO,
FMA, FOD, FLT and IIM etc records throughout the day / shift a pallet at a
time, about one transaction every 10 seconds). BPCS sometimes locks records
for ages whilst it muses over some SQL statement or another and if a record
locking conflict occurs our routine times out, rolls everything back and
posts to a 'holding' area for users to try again later. It has saves
hundreds of hours of support and data fixing. The same scenario with BPCS
code just fails the update! It's a shame but technologies like commitment
control don't seem to be in favour any more. As for performance, I'm with
you. Journalling is a great DR enabler anyway and I've never had to upgrade
a box purely to switch it on (unlike going BPCS 4 to 6), aside, its not the
overhead it used to be on older boxes / OS's. If you do journal your BPCS
database - don't look at the journals too closely - I've found some really
scary things going on!

Paul

At 20:23 03/06/99 -0400, you wrote:
>Does the AS/400 version of BPCS have this problem (i.e. failed transactions
>leaving duplicate records laying around)?  I used to run a MACPAC shop,
>which includes journaling and commitment control in all its update programs.
>In the TEN years I ran that software, I NEVER had this problem.  If the user
>kicked the plug out mid-transaction, the box fixed it for me.  I always
>crowed about the benefits of journaling and commitment control, but the
>reply was usually a concern about performance.  Whatever performance hit I
>took was worth all the extra sleep I got not having to de-dupe files and
>back out failed transactions.
>
>Has anyone implemented this in a BPCS environment?  It's a real bear to do
>it right.
>
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>Purge and Archive your AS/400 Data Without Programming with ARCTOOLS (tm)
>Add archiving to BPCS' purge programs WITHOUT PROGRAMMING.
>DCSoftware, Inc.
>(508) 435-8243
>(508) 435-4498 (fax)
>http://www.arctools.com
>mailto:info@arctools.com
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>-----Original Message-----
>From:  owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com] On Behalf
>Of James Touchtone
>Sent:  Thursday, June 03, 1999 6:34 PM
>To:    BPCS-L@midrange.com
>Subject:       RE: Duplicates in BPCS files - illusion?
>
>We also have the IWI and ILI duplicates problem. We are running HPUX
>6002 with Informix. The IWI table is our biggest offender, while the ILI
>only occasionally creates duplicates. We have found that the ILI duplicates
>are often created when a user's PC crashes in the middle of
>INV500D.
>
>
>>From: Christine Hales <chales@schukra.com>
>>Reply-To: BPCS-L@midrange.com
>>To: "'BPCS-L@midrange.com'" <BPCS-L@midrange.com>
>>Subject: RE: Duplicates in BPCS files - illusion?
>>Date: Thu, 3 Jun 1999 07:57:46 -0400
>>
>>
>>
>>  What causes duplicates?
>>
>> >  I have seen duplicate records in some files cause this type of problem.
>> >  You might want to verify that  IWIL04 does not have any duplicates.
>>
>>[Christine Hales]
>>
>>              We are a 6002 HP/Oracle shop, and are constantly trying to 
>battle
>>system-created duplicates.  It seems the biggest offender is the IWI table.
>>  I am not sure if and why it happens on the 400 side - but for us, if the
>>transaction cannot obtain the lock on the IWI record, it just decides to
>>create a new one.  Of course the helpline can't duplicate it......
>>
>>              We routinely clear these out, and run the update from ILI to 
>make sure
>>everything is in sync.  Is this still happening in 6004?
>>
>>                              -Christine
>>
>
>
>+---
>| 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
+---