B
Renaming or Changing the Location of Shared Databases

Appendix summary

This appendix provides information about how you can change the default names of the Financial Analyzer shared databases after installation. It also explains how to change the location of individual shared databases from the default locations into which they are installed.

List of topics

This appendix includes the following topics:

• Changing the Default Name of a Shared Database

• Modifying the Configuration File

Changing the Default Name of a Shared Database

Introduction

This topic discusses the shared databases that are created when you install a Financial Analyzer workstation and provides the default names given to each database.

Shared databases and their default names

When you install Financial Analyzer, a set of databases with the following default names is installed in the SHARED directory:

• ofas.db

• ofastask.db

• ofasctl.db

• ofaslck.db

In some circumstances you may wish to change the name of these databases. You can rename all or any number of them.

Moving a Shared Database from Its Default Location

The set of shared databases discussed previously is installed by default into the SHARED directory. Under some circumstances you may want to move some of these files into different directory locations.

Modifying the Configuration File

Introduction

If you rename or move a shared database file, you must edit the system configuration file, ofasyscf.cfg, to reflect the changes you have made. This topic describes the changes that you need to make to the settings in this file.

System configuration file

The [Shared] section of the system configuration file (ofasyscf.cfg)contains the following settings:

[Shared]

SHAREDACCESS= . . .

SHAREDCFGPATH= . . .

SHAREDHOST= . . .

SHAREDPORT= . . .

SHAREDHOSTTYPE= . . .

If you rename or move the shared database files, you need to add settings to this file so that the system can find and access the files under their new names or in their new locations.

Settings to add

The following table lists the settings to add to the ofasyscf.cfg file if you rename or move the shared database files.

Note: When you add settings to the ofasyscf.cfg file, you must match the capitalization exactly as it is shown in this table.

IF you . . .	THEN add this line to the configuration file . . .
rename the ofas database file,	OFASNAME=new name of the ofas database.
move the ofas database from the default SHARED directory,	OFASPATH=new location of the ofas database.
rename the ofastask database file,	OFASTASKNAME=new name of the ofastask database.
move the ofastask database from the default SHARED directory,	OFASTASKPATH=new location of the ofastask database.
rename the ofasctl database file,	OFASCTLNAME=new name of the ofasctl database.
move the ofasctl database from the default SHARED directory,	OFASCTLPATH=new location of the ofasctl database.
rename the ofaslck database file,	OFASLCKNAME=new name of the ofaslck database.
move the ofaslck database from the default SHARED directory,	OFASLCKPATH=new location of the ofaslck database.

Example: Renaming the ofas.db database

Configuration that requires the database to be renamed

If your system is configured so that a single instance of Express Server is associated with two or more Administrator workstations (one of which may be a Super administrator workstation), you need to rename the ofas.db database of one of the administrators so that each is known to the Express Server instance by a unique name.

Why a unique database name is required

When the ofas.db database reaches a maximum size of 2GB, Express Server creates an extension file and names it using the shared database name. The default name for this extension file would be ofas.001.

Note: Express Server automatically places the extension file in the directory that you specified in the ExtensionFilePath setting of the File I/O option in the Express Configuration Manager.

If you do not rename one of the ofas.db database files, conflicts can occur within Express Server if extension files become necessary.

Sample procedure: Renaming the ofas.db file

The following sample procedure describes renaming a database file:

1. Rename the appropriate shared database file.

2. Edit the appropriate system configuration file and add an OFASNAME setting in the [Shared] section of the file, as shown in the following example.

   [Shared]
SHAREDACCESS= . . .
SHAREDCFGPATH= . . .
SHAREDHOST= . . .
SHAREDPORT= . . .
SHAREDHOSTTYPE= . . .
OFASNAME=ofas1

   For detailed information about editing configuration files, refer to Chapter 4.