RE: commit cycle ID

["Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxxxxxxxxx>]

This particular problem that I'm researching is already a few weeks old
and I no longer have the joblog to support this research.  I still
couldn't quite agree with you about the database did a partial rollback
of a commitment cycle.  Commitment Control is suppose to protect this
type of scenario from happening.  


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, March 21, 2008 7:42 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: commit cycle ID

   Surely unrelated to RPG...  Regardless, the R-BR and R-UR need not be
from a ROLLBACK initiated by the program nor command-line ROLLBACK
request.  The database itself can initiate an effective rollback of an
operation; e.g. as implementation for an error condition.  Review all of
the details for the entry to determine what could have effected the
rollback of that one row; including at a minimum, the row number and
trigger & RI indicators, and flag.  The limited view of what is given,
is a /blinders on/ view of the scenario.  Full entry details combined
with the details from the joblog for that timestamp, might be even more
revealing.

Regards, Chuck
--
  All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer

Lim Hock-Chai wrote:
> I'm a bit confuse about journal entries below, the program that did 
> the update on BLCNYPF and BLCNPPF files is a ILE RPG program that runs

> under the QILE activation group.  All these transactions have the same

> Commit Cycle ID.  The last two entries (BR and UR for BLCNPPF file) 
> seems to indicate that the program has did a rollback.  If that is the

> case, why am I not seeing the similar BR and UR transactions for 
> BLCNYPF file?
>  
>     COMMIT     DATE       TIME    JOB      PROGRAM     OBJECT   TYPE
>     CYCLE ID                      NUMBER   NAME        NAME

>  874,467,656   031108  141,304   854,398   BL3120RP    BLCNYPF   UB 
>  874,467,656   031108  141,304   854,398   BL3120RP    BLCNYPF   UP 
>  874,467,656   031108  141,304   854,398   BL3120RP    BLCNPPF   UB 
>  874,467,656   031108  141,304   854,398   BL3120RP    BLCNPPF   UP 
>  874,467,656   031108  141,304   854,398   BL3120RP    BLCNPPF   BR 
>  874,467,656   031108  141,304   854,398   BL3120RP    BLCNPPF   UR 

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.