[Info-Ingres] FW: Recover checkpoint to server with different locations

[Martin Bowes]

Hi All,

Yes a table/index create has a hard coded path in it...

Heres a quick auditdb -a
Fcreate : Transaction Id 00004e3250108720 File /dbdata1/TE/ingres/data/default/bowtest/aaaaabaa.t00

There are also Frenames....

So it appears that I need to edit the dumps/journals as well.

Rather than decode the blasted journals with od does anyone know where I can find the journal file descriptions?

Has anyone done this before?

Marty

[Karl Schendel]

On Nov 29, 2011, at 5:30 AM, Martin Bowes wrote:

> Hi All,
>
> Yes a table/index create has a hard coded path in it...

I never understood why the server uses hardcoded paths anywhere, after going
to all the trouble of doing location support. I'm going to fix that before I die. :-)
(and it might take that long...)

>
> So it appears that I need to edit the dumps/journals as well.
>
> Rather than decode the blasted journals with od does anyone know where I can find the journal file descriptions?

As far as I know, the journals are the same as the transaction log.
There might be a header of some kind, I'm not sure. The log record
definitions are in back/dmf/hdr/dm0l.h. The low level journal
file readers are in cl/clf/jf_unix_win/jf.c and in back/dmf/dmp/dm0j.c
(the JF routines are the CL equivalent of read() and write(), and
the dm0j routines give you read-a-record.)

Karl

[Martin Bowes]

Hi Karl,

Looks nasty, I'll go for the 'brute force and bloody ignorance' option...which has always been a personal favorite.

A simple program can scan for the known old paths and then substitute them for new paths (correctly padded to width).

I'll recode my recovery application and see what explodes this time.

Marty

_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres