asdbget: journal

[Sean Porterfield <sporter@xxxxxxxxxxxx>]

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?)

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?

Thanks!

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