Re: catch table changes

----Csaba Kabai wrote:----
> The journaling sounds well, thanks for the advice.

Glad to help! :)

>The only things to guess howto track real-time the journal changes :).

Well, you can write a program on the iSeries that you can use with the
RCVJRNE command.  This command allows you to have a program that get's
invoked as journal entries arrive on the journal.  This program, however,
is best suited to a traditional program object (COBOL, RPG, etc), not Java.
There is a system API (the name escapes me now) that you could call also
that allows you to manually receive entries from the journal, but that
would have to operate in more of a polling mode instead of the event driven
mode of RCVJRNE.

Really, it's best to write the journal receiver in a traditional language
on the iSeries if you can do it.

I think Chapter 19 of the Backup and Recovery manual would explain
everything to you.  Here's a link to that manual on the IBM Publib site:
http://publib.boulder.ibm.com/iseries/v5r1/ic2924/books/c4153045.pdf

>Yes, i like to perform some additional steps based on the changed tables.

I don't know your full needs, but I'm wondering if you might actually want
to use a trigger program to accomplish your goals.  In either case, I think
these tasks are often better suited to a traditional language based program
on the iSeries.  Java, although integrated nicely with the iSeries and
getting better with every release, doesn't have access to the entire range
of things that traditional programs have.

>Possible to write a  "java-service" to OS400?

Sure. :)  There are a lot of ways to do it, but it depends on your
particular needs.

If you could give us a little more information about what you are trying to
accomplish, we can probably give you better answers.

----------------------------------------------------------------------
Chris DeLashmutt
Senior R&D Analyst
LeasePlan USA
1165 Sanctuary Pkwy., Alpharetta, GA  30004
Phone: 678-202-8695
Fax: 678-921-4895
----------------------------------------------------------------------