Re: Weird issue with displaying journal data for a file

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I'd have to agree with Gqcy & Gary...I'm guessing you're not actually
looking at the same record..

Include the RRN, library and file...might also include commit ID.

Finally, what's your WHERE statement look like?

Wondering if you're missing before/after rollback....

Charles

On Wed, Aug 22, 2012 at 12:09 PM, Jeff Young <jyoung0950@xxxxxxxxx> wrote:
> I have a file that is jourlaned with both before and after images.
> When I retreive the journal data for the file to a database file and query
> it using SQL, I see the following results:
>     JOSEQN   JOENTT  JOTSTP                      JOPGM
> IFITEM                        IFQWIP           IFQCMM
>  1,073,529     UB    2012-08-22-09.51.24.902976  INUPIB
> *EZRELEASE                       .00              .00
>  1,073,530     UP    2012-08-22-09.51.24.902976  INUPIB
> *EZRELEASE                       .00              .00
>  1,082,218     UB    2012-08-22-10.00.20.052000  MOUPSH
> *EZRELEASE                    251.46           230.20
>  1,082,219     UP    2012-08-22-10.00.20.052000  MOUPSH
> *EZRELEASE                    251.46           230.20
>
> I have manualy verified this information by displaying the journal data for
> the file and viewing each record.
> My question is: Since the entry at sequence 1,073,530 (after update) shows
> a value for IFQCMM of 0.00, why does the next entry for that item (before
> image) at sequence 1,082,218 show a value of 230.20?
> There were no records in the journal for this item between 1,073,530 and
> 1,082,218.
>
> Thanks,
> --
> Jeff Young
> Sr. Programmer Analyst
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.