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

[Martin Bowes]

I haven't tried it to see if auditdb would be happy but what I would do is:
Extend Step 2 to use alterdb -next_jnl_file to force the required extra number of journals on the test database
Extend Step 5 to copy over j0000001.jnl, j0000002.jnl, etc.

That's on the suck it and see category.

Martin Bowes 

-----Original Message-----
From: Paul White [mailto:paul.white at shift7solutions.com.au] 
Sent: 18 April 2018 01:15
To: Info-ingres at lists.planetingres.org
Subject: [Info-ingres] Reading "OLD" Ingres Journal Files

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



_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres