Hi,
On Wed, 19 Apr 2000, Sean Porterfield wrote:
> I'm back to dabbling with the idea of journaling files and downloading
> only the changes with asdbget instead of getting the whole file every
> time.
>
> I'm trying to follow Mike's directions, which I assume work for him.
>
> > 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.
> >
>
> I switched steps 1 and 2 since the CRTJRN command wanted a JRNRCV
> parameter. So I used CRTJRNRCV to make two journal receivers, CRTJRN to
> create the journal with the first journal receiver, and STRJRNPF to let
> the system know what file I wanted to journal (can it do multiple files
> all in one journal? or separate for each?)
You can have as many physical files in one journal as you want.
> Then I performed an operation that added a record to the file. I used
> the CHGJRN command to switch to my second journal receiver. I used
> DSPJRN to create a physical file and downloaded it via asdbget.
>
> There is a record with JOCODE=R and JOENTT=PT that indicates I added a
> record, but the JOESD field has a bunch of garbage.
>
> Is there any way to get FIELD=VALUE information for the record I added?
The problem is that journal records have a different format from regular
records. This additional header information contains info about each
journal entry (time, file, ADD/DEL/UPDATE, etc.). I have a modified
version of as400toascii which can handle journals. This would be a good
basis for modifying asdbget. I don't have access to it at the moment, as
I'm waiting for my computer to be shipped down to California, but I should
be able to post info on where to get it in the next week or two.
Mike
+---
| This is the LINUX5250 Mailing List!
| To submit a new message, send your mail to [EMAIL PROTECTED]
| To subscribe to this list send email to [EMAIL PROTECTED]
| To unsubscribe from this list send email to [EMAIL PROTECTED]
| Questions should be directed to the list owner/operator: [EMAIL PROTECTED]
+---
