Right now we're using a program that uses the receive journal entry
command to enter changes into a separate library from which we build
text files to send down to the windows server. There a program applies
the changes to a Firebird database that the clients sync from.

This works, but I was hoping that DB2 UDB might have some tools that
integrate it more tightly with DB2 on the AS400 so that we could use to
improve the sync process.

David Knaack

-----Original Message-----
From: michael
[mailto:db2udbdba-ezmlmshield-x89288977.[Email address protected]
Sent: Friday, March 30, 2007 6:17 AM
To: LazyDBA Discussion
Subject: RE: AS400 library sync to DB2 UDB?

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



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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