Re: 0.15.6!!

[mmadore <mmadore@xxxxxxxxx>]

Hi,

> Hehe, probably not.  Really, this list has been about Linux <=> AS/400 
> connectivity, and let's just say that if it gets too big a topic, we'll split
> it up into seperate lists.
> 
> Michael Madore has done this by retreiving journal files and using them to
> sync an Oracle databse server, and also done this with FTP and his as4002unix
> utility, which was hacked by myself, with input from Mike, to become asdbget.
> I'll have to post it soon.  (Again, when my ISP dries up :)
> 
> We do know that FTP transfers appear to be much faster than ODBC/DRDA
> transfers.  We also know that certain types of database files refuse to
> transfer via FTP - if you populate a field with 'NULL' via an SQL statement,
> for example.
> 
> I can't really comment on how he's doing the journal file thing... Mike?

This is working quite well for us.  Here is a synopsis of how we do it.
Details are available if anyone is interested.

1) Create a journal
2) Create two journal receivers to hold the journal entries
3) Start journaling the physical files you want to mirror
4) Once a day, or however often, change journal recievers (switch between
the two)
5) Run DSPJRN to dump the journal entries to a database file.
6) Download the database file
7) Convert the entries in the database file to SQL statements(INSERT,
UPDATE, DELETE).  I have a utility for this which I can make available.
8) Run a perl script which uses DBI to execute the SQL statements.  I have
a script for this also.

The database on Linux is now synchronized with the database on the 400.
We use this for Oracle, but it should work with any database supported by
DBI.  You may also have to load the database initially.  I have utilities
to do this on Oracle.

Mike Madore



+---
| This is the LINUX5250 Mailing List!
| To submit a new message, send your mail to LINUX5250@midrange.com.
| To subscribe to this list send email to LINUX5250-SUB@midrange.com.
| To unsubscribe from this list send email to LINUX5250-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---