Hi David -

Yes, AS/400 libraries (collections) can certainly be journaled. I don't
know of products that will apply the journal changes to a UDB database,
but you could certainly roll your own. You want to apply changes to UDB
from an AS/400 database, right? You could do a couple things: have a
server program on the AS/400 that uses the RCVJRNE (Receive Journal
Entry) command to take the journal change and apply it to UDB, or use
triggers on the AS/400 files. In either case, you would then
programmatically insert/update/delete to the UDB database. IBM's
Distributed Relational Database Architecture (DRDA) provides the
built-in support to do that. I do this in a batch mode using an RPG
program to process changes from AS/400 to a Windows UDB database.

HTH...

- Michael

> -------- Original Message --------
> Subject: AS400 library sync to DB2 UDB?
> From: "David Knaack "
> <db2udbdba-ezmlmshield-x96693214.[Email address protected]
> Date: Thu, March 29, 2007 11:26 am
> To: "LazyDBA Discussion" <[Email address protected]
>
> Greetings,
>
> I'm looking for information about syncing or replicating changes to an
> AS400 library to a DB2 UDB database.
>
> We have a Windows application that runs disconnected that performs daily
> sync operations to a Windows server. The windows server must stay in
> sync with changes to the AS400 library. Right now we do this with some
> custom programs on the AS400 and windows server (which is using the
> Firebird database), but I'm hoping that there might be a better way to
> do this by switching our windows server to use DB2 UDB.
>
> I'm not familiar with the AS400, but evidently the libraries use the
> journaling feature. Is there a way to hook DB2 UDB into this to do both
> disconnected, batched updates (for when the windows server is not on a
> fat pipe) and for live updates.
>
> Any suggestions?
>
> Thanks,
> Dave K


DB2 & UDB email list listserv db2-l LazyDBA home page