Re: asdbget: journal -- LINUX5250

OK, I'm not in a huge hurry to work on it, so whenever you get a chance would be
great.  Thanks!

Mike Madore wrote:

> 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 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
+---