Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Recovery in Alternate Locations with REDIRECT

The REDIRECT feature is a useful feature allowing a file originating in one directory structure to be repositioned into another directory location during dynamic dump restore. This support has been extended to FairCom DB automatic recovery.

Redirection rules can be specified by using the following configuration entry one or more times in the server configuration file ctsrvr.cfg:

REDIRECT <old path> <new path>

The REDIRECT entry redirects filename references in the transaction logs during automatic recovery to the specified new filename. This option is useful when FairCom DB data and index files are moved to a different location (on the same system or on another system) before running automatic recovery.

To specify an empty string for one of the REDIRECT arguments use a pair of double quotes ("").


If a file originally existed with the name and path C:\Documents and Settings\Administrator\c-tree Data\customer.dat and now exists as the file D:\Documents and Settings\Guest\customer.dat, the following option will allow automatic recovery to proceed and find the file in its new location:

REDIRECT "C:\Documents and Settings\Administrator\c-tree Data" "D:\Documents and Settings\Guest"

Here’s a similar example using Unix paths, where the original file is named /users/administrator/c-tree data/customer.dat and the file now exists as /users/guest/customer.dat:

REDIRECT "/users/administrator/c-tree data" "/users/guest"

Note: Use double quotes when a filename contains spaces.

Updating IFIL Filenames

As a result of redirection, if the IFIL resource of the file contained a path, this path would be incorrect after the file was redirected to the new location. To support copying FairCom DB files from one directory location to another (on the same system or on a different system) and accessing them in their new location, it is necessary to update any filename paths in a FairCom DB data file’s IFIL resource.

The FairCom DB configuration option REDIRECT_IFIL <filename> provides support for automatically modifying redirected files on the server. When this option is specified, on server start up (after automatic recovery completes) the file named <filename> is opened and its list of file names is read from it. <filename> is a text file containing one FairCom DB data file per line. For each file specified in <filename> FairCom DB opens the file and uses the filename redirection rules (specified with one or more of the REDIRECT options) to change the data and index file paths in the IFIL resource of the file.

Refer to the FairCom DB ctredirect standalone utility to manually modify files that may have been moved.