dbTalk Databases Forums  

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

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] FW: Recover checkpoint to serverwith different locations in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] FW: Recover checkpoint to serverwith different locations - 11-29-2011 , 04:30 AM






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

Reply With Quote
  #2  
Old   
Karl Schendel
 
Posts: n/a

Default Re: [Info-Ingres] FW: Recover checkpoint to serverwith different locations - 11-29-2011 , 05:58 AM






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

Quote:
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...)

Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.