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