RE: Duplicates in BPCS files - illusion?

["David Shea" <dshea@xxxxxxxxxxxx>]

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
+---