[Info-ingres] Reading "OLD" Ingres Journal Files

[Paul White]

This tech tip is from the December 2016 OpenROAD and Ingres bugfix notice. 

I could not find the tech note on the Actian community pages.
Question. Can the procedure be simply extended to run for many journals?



Tech Tip: Reading "OLD" Ingres Journal Files

Sometimes old journal files need to be examined via auditdb, but
unfortunately, the database where they belong has moved on and any reference
to the particular journal(s) is removed. The process to review them is quite
simple:

1.    Create a database (e.g. createdb test).
2.    ckpd +j test - This will create a journal file named j0000001.jnl.
3.    Create table(s) that are referenced in the journal file or a subset of
the tables if you are only after specific table(s).
4.    Stop Ingres.
5.    Copy the journal file you want to examine into the
$II_SYSTEM/Ingres/jnl/default/test directory and rename it to j0000001.jnl.
6.    Start Ingres.
7.    auditdb test>filename.txt - All journal information will be written to
this file.

If you have more than one journal file to examine, copy them in one at a
time.


&
Shift Seven Solutions
84 Annie Drive Peregian Beach QLD 4573
Mob 0414 681799
Ph 07 5448 2137
www.shift7solutions.com.au