Can I replicate my database on another system without using a tape or disk file

Reality does not have any inbuilt ability to replicate a database on another system, but it has the building blocks to enable this to be done by using Unix named pipes.

To replicate a database on machine1 to a database on machine2, first of all ensure the remote tape server is installed on machine2. Then create a named pipe on this machine:

mknod /tmp/rtpipe p

Setup a tape image on machine2 that points at this pipe. To setup a temporary tape image use:

:T-DEVICE 1 /tmp/rtpipe 9
:T-ATT 1

On machine1 setup a remote tape that points to the named pipe on machine2. To setup a temporary device use:
:T-DEVICE 1 machine2;/tmp/rtpipe;9 8
:T-ATT 1

On machine1 initiate a FILE-SAVE or SAVE-IMAGE using the device setup above.

On machine2 restore the system by doing one of the following:
If saving using FILE-SAVE (note use of extra T-FWD)
:T-FWD * Skip write check
:T-FWD * Skip dummy boot loader
:T-FWD * Skip dummy ABS frame
:ACCOUNT-RESTORE * * Specifying the device setup above
:T-FWD * Skip stat file to clear pipe

If saving using SAVE-IMAGE:
:LOAD-IMAGE ;   * Specifying the device setup above.

This works between Unix/Unix and Unix/Windows or Windows/Unix. There is currently no mechanism to do Windows/Windows as Windows does not support named pipes in this way, although a Unix/Linux intermediary could be used with both Windows systems using remote tape to access the pipe.

Note if moving data between machines with a different byte order then FILE-SAVE/ACCOUNT-RESTORE must be used (followed by a SYS-UPDATE). Please also note that in order to use this functionality you will require fix V12.0.0.0012 for Reality V12.0.

Back to articles