RE: Fastest way to get a unique identifier/tracking column changes

I use journaling and commitment control extensively, but that's not the
presenting problem.  I already have a couple of major applications that
track activity from the journal receivers, SNDJRNE the ending position,
etc., so that's not new ground.  I just don't think it's the right approach,
and sooner or later I'm going to engineer the mission-critical
read-the-journal receiver processes away in favor of trigger programs.

I suggested a trigger program because extracting the changes from a journal
receiver requires a process (or "one more process") to read the journal
receiver entries, and IMHO that adds an additional (weak) layer in the
system while offering the possibility of some boneheaded programmer deleting
an unprocessed journal receiver.  Since I'm going to have the trigger
program overhead already, I'm going to add a little more function to it.

In most cases, only a few columns will be changes per record, and this
high-volume system (a logistics order management system feeding my
transportation management system) precludes saving complete record images.
The users want to see the changes to a specific column, not the whole
record, and if I have the details, I could reassemble a history from the
detailed changes I'll be trapping.

-rf

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Jeff Silberberg
> Sent: Monday, July 12, 2004 11:45 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: Fastest way to get a unique identifier/tracking column
> changes
> 
> 
> Okay,
> 
>          I have to ask. What's wrong with what the Journal Receiver
> contains ?   Can't you just use it or at least use it to
> populate your history..
> 
>          JMS..
> 
> At 10:21 AM 7/12/2004, you wrote:
> >The challenge is to determine a way to get the entity number quickly.
> >Having a control file is okay but probably limiting performance-wise;
> >another possibility is a journaled data area.  Is there a system API
> >providing a guaranteed unique sequential number?  Or is there a better
> >approach for tracking column-level changes?
> >
> >
> >
> >Thanks,
> >
> >Reeve
> 
> Jeffrey Silberberg
> CompuDesigns, Inc.
> Atlanta, GA. 30350
> (770) 399-9464
> As soon as I know the answers
> They change the questions !
> --
> 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.